Formulas Based on Cell Format
 

Is there a way to write an if/then formula based on a cell's format. For
example, if cell A1 is red, then red? Any help, once again, would be greatly
appreciated.

Thank You!

A B C
1
2
3 =IF(A1=??red format??, "red", "white")

Formulas Based on Cell Format
 

Something here may help..........

http://www.cpearson.com/excel/colors.htm

Vaya con Dios,
Chuck, CABGx3




"HROBERTSON" wrote:

Is there a way to write an if/then formula based on a cell's format. For
example, if cell A1 is red, then red? Any help, once again, would be greatly
appreciated.

Thank You!

A B C
1
2
3 =IF(A1=??red format??, "red", "white")