Cell color

  • Thread starter Thread starter Bubba
  • Start date Start date
B

Bubba

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top