Hi,
Like RickyDee, I am trying to figure out how to have a
cell change color automatically. But I dont' think he's
on the same track as I am.
I'll write it out in 'long hand'.
If b1 > C1 then change D1 to GREEN and place OVER in D1
If b1 < C1 then change D1 to RED and place UNDER in D1
Can't seem to find this in the HELP file, and conditional
formatting doesn't seem to want to go that far.
Thank you.
Norman Harker - 21 Jan 2004 08:55 GMT
Hi Bubba!
You can't do it in one operation.
In D1 put:
=IF(B1>C1,"OVER",IF(B1<C1,"UNDER","EQUAL"))
The apply conditional formatting to D1

Signature
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.