Changing a cell value based on the color of aSolved/Closed

Question

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

Farzan · Accepted Answer

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

rizvisa1 · Answer

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.

pDude · Answer

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

Changing a cell value based on the color of a

3 responses

Similar discussions

Subscribe To Our Newsletter!