MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Getting a Cell's Color using a macro

Posted by Kev on September 21, 2000 5:25 PM

I have an excel sheet that has numbers which are color coded. I need to find the cells of a certain color and then get their data in order to make certain calculations. How do I get the color of a given cell?


Posted by Celia on September 21, 2000 6:16 PM


fontColor = Selection.Font.ColorIndex
cellColor = Selection.Interior.ColorIndex