Excel 365 Power Query Combined Files and extract selected data

[ga07]

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

[raisurrahman · Accepted solution]

@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.

[v-venuppu]

Hi @ga07 ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-venuppu]

Hi @ga07 ,

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

[v-venuppu · Accepted solution]

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.

[raisurrahman · Accepted solution]

@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.

[ga07]

Hi

I want to extract data from any backgroud colour cell

[rubayatyasmin]

Hi @ga07 

Your question is not clear to me. Could you please post a sample output and data? 

[ga07]

So I wanted to extract cell contain any backgroud colour I want to extract this information