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?

Thanks,
kc


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

kc

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

Celia