Changing a cell value based on the color of a

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

3 responses

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
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
1
Hi mate, could you please share the code you used ?

Cheers,
Farzan
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 17, 2010 at 09:21 AM
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.
-1