Color Checking

[Dragon]

Hi,

I have a sheet that had different cell background colors for different
status. This coloring is done manually. Is there a way for me to create text
based on the cell color? For example, in a new column I would type:

B1 = if(color(A1) = Red, 'Inactive', if(Color(A1)=Yellow,'Tentative',
if(Color(A1)=Green,'Active')))

I guess the color names could also be a numerical value.

Thank you.

 

[Jerry W. Lewis]

You have to use VBA to get at color properties; see

www.cpearson.com/excel/colors.htm

Jerry

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.ColourCounter.html