Excel 365 Power Query Combined Files and extract selected data

ga07 

As far as I know, this isn’t possible right now—Power Query only reads raw values, not cell formatting, so it can’t detect a cell’s fill/background color.

Hi ga07 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you raisurrahman rubayatyasmin for the prompt response.

As mentioned by raisurrahman, 

Power Query can’t read cell formatting - it only imports raw values, so background colors (red/blue) aren’t detected directly.However, you can work around this by using a helper column or VBA macro that tags each colored cell (e.g., “Red” or “Blue”) before loading into Power Query.Alternatively, use the GET.CELL formula via a named range to return the color index into a column, then import that column.Once color values are converted to text, Power Query can easily filter and report them.Hope this helps you create your report more smoothly.