Conditional formatting and/or

Hi all,

This is probably a really obvious one but I can't seem to get it right with the slight differences in code with conditional formatting.

I currently use
=IF($C$2="Apple",ISBLANK($D$24))

Which works fine and will colour the cell if C2 = Apple and D24 is blank

What I need is the cell conditioning to trigger if C2 = Apple OR Orange and D24 is blank

Any ideas?

Thanks in advance and as always

Try this:

=AND(OR($C$2="Apple",$C$2="Orange"),ISBLANK($D$24))

You don't need IF in a conditional formatting rule, and I don't think your original formula is really doing what you think it is, anyway. Unless, of course, you man something entirely different.

Not sure that is working the way you think it is, but OK.

Try this...
=and(or(C2="Apple",C2="Orange"),D24'"")

Must be an echo in here...here.... lol

oops left out an =....
=and(or(C2="Apple",C2="Orange"),D24="")

Thanks all, I should mention, the reason I have ISBLANK is I want the formatting to trigger only if Apple/Orange is selected via dropdown and D24 is blank. Basically it's a subtle queue for a cell to be filled out and if it isn't the cell background colour is red. If the cell isn't blank, I want all formatting to be removed.

Do I look like a gent???

I don't quite get what you are saying. Provide a sample workbook to illustrate this.

ISBLANK and ="" are basically the same thing

There is nothing magical about a drop down (data validation), it acts in the exact same way as if you had entered the data manually, and excel formulas only see the data in the cell as if it had been entered manually.

The only real advantages of using a DD is that it saves typing, avoids typos/spelling mistakes, restricts entry to what you specify, and maybe saves a bit of time in entering data.
Other than that, no difference to manual entry

Did you try the suggested CF rules yet? they should do exactly what you want.
=and(or(C2="Apple",C2="Orange"),D24="")

There are instructions at the top of the page explaining how to attach your sample workbook.

I see this is now marked as SOLVED? Did you try the suggestions?

Another hit and run, Ford.

Apparently so, Ali

Thanks - appreciated.