I have a spreadsheet which cells in are colored meaningfully.
Does any body know how i can return the background color value of a current cell in Excel sheet?
You can use Cell.Interior.Color, I've used it to count the number of cells in a range that have a given background color (ie. matching my legend).
Cell.Interior.Color
1.4m articles
1.4m replys
5 comments
57.0k users