color to value

Copper Contributor

I am wanting to pull information off a spreadsheet that has been color coded by week / location. The formatting is not value conditional just plain formatting. Is there a way to backward generate a value against the color so I can then pull it into power query?

1 Reply

@samdthompson 

 

Here's a website with info on how to pull information regarding various cell attributes, including color, from the cells. https://exceljet.net/excel-functions/excel-cell-function