Question posted 2009 ยท +11 upvotes
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?
Accepted answer +12 upvotes
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).
Top excel-vba Q&A (6)
- How to clear the entire array? +58 (2010)
- How to change Format of a Cell to Text using VBA +55 (2011)
- Download attachment from Outlook and Open in Excel +43 (2012)
- Can a VBA function in Excel return a range? +36 (2009)
- 2 Dimensional array from range +34 (2013)
- Hiding an Excel worksheet with VBA +33 (2009)
excel-vba solutions on this site
.