Jun 20 2021 03:31 PM
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?
Jun 22 2021 08:26 AM
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