Color Checking

D

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.
 
Top