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

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.

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

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

"waladd" wrote:

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.

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

Check this link - it may be helpful for you:

http://xldynamic.com/source/xld.ColourCounter.html

"waladd" wrote:

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.