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.