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 3435 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
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
757
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.