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

- - Latest reply:  Farzan - Sep 15, 2010 at 04:11 AM
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
See more 

3 replies

Best answer
5
Thank you
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

Say "Thank you" 5

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

CCM 5630 users have said thank you to us this month

1
Thank you
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
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
754
-1
Thank you
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.