Forum Discussion
Excel 365 Power Query Combined Files and extract selected data
Hi I have 30 excel sheets I want to export Red background cell value and Blue background value
I want to export below values in red,date, and
| Tuesday 7th |
| Urodynamics - (R) |
| JN |
Please can anyone help me I want to make report usong power query
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.
7 Replies
Hi ga07
Your question is not clear to me. Could you please post a sample output and data?So I wanted to extract cell contain any backgroud colour I want to extract this information
Hi
I want to extract data from any backgroud colour cell
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.
