Can I create an if statement that looks for a specific cell color?

W

waladd

This formula worked:
=IF('[ANCILLARY
2007.xls]0211-0224'!$E$4="9a-5p","ON","OFF")

I realized after I began nesting true statements that if it's possible it'd
be alot easier if I could reference the cell's color. something like:
=IF('[ANCILLARY
2007.xls]0211-0224'!$E$4="cellred","SICK",IF('[ANCILLARY
2007.xls]0211-0224'!$E$4="cellyellow","ON","OFF")

Any help would be greatly appreciated, I am using Office 2003 Pro.
 
J

Joel

Look at the help on the cell function. Insert the function. there is a help
option before tthe function is added (bottom left corner of pop up window).
 
Top