Forum Discussion
color to value
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
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
