Cell color

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

Norman Harker

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using icon sets with relative references 0
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Conditional Formatting and cloring cells and date calculations 1
cond. formating quesiton 1
Excel Formula for Single Cell Adress 2
Applying Max Conditonal Formatting to an entire row when condition 2
Combining several cells into single equasion? 1
Conditional format SUMPRODUCT 3

Top