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

pDude - Mar 17, 2010 at 02:47 AM - 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 

4 replies

Best answer
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

Thank you, pDude 1

Something to say? Add comment

CCM has helped 1680 users this month

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

Cheers,
Farzan
Best answer
1
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

Thank you, Farzan 1

Something to say? Add comment

CCM has helped 1680 users this month

rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Mar 17, 2010 at 09:21 AM
-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.