Changing a cell value based on the color of a [Solved/Closed]

Report
-
 Farzan -
Hello,

Is it possible to populate a cell in Excel 2003 with a number value that is based on the color of an
adjecent cell? ie
A2 = 0 if B1 is transparent , 1 if B1 is blue, 2 if B1 is black, 3 if B1 is green, 4 if B1 is red etc etc

Thanks

3 replies

Hi mate, could you please share the code you used ?
I read through that article but I didn't understand which part should I use?

Cheers,
Farzan
5
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Hi

Thanks for the reply.

After some more Googling I came across this article which was what I was looking for.
http://www.cpearson.com/excel/colors.aspx

Thanks again
Hi mate, could you please share the code you used ?

Cheers,
Farzan
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
764
You have to write a function for it and call that function. Other way could be if one know how the cells got color in the first place.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!