MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Conditional Formatting - 2 conditions?


Posted by ren on November 16, 2001 12:45 PM

I have one conditional format which says:
cell value is equal to or less than =today()
this turns red

Now I have entered the following for the 2nd condition. I want it to remain black.
=NOT(ISBLANK(F32)) (nt)

It is staying red. How do I make a statement that does what I want, red if this, black if this???

Posted by Barrie Davidson on November 16, 2001 12:49 PM

What colour do you want it if the cell is not blank AND the value is less than, or equal to, today?

Barrie
Barrie Davidson

Posted by ren on November 16, 2001 12:58 PM

Black

Posted by ren on November 16, 2001 1:03 PM

Black

Posted by ren on November 16, 2001 1:06 PM

=(H32="Not available" or "Not applicable) ???

=(H32="Not available" or "Not applicable)

How do I make this formula work?

I am only able to add 3 conditions so can I put these two together?
=(H32="Not available")
=(H32="Not applicable)

Posted by IML on November 16, 2001 1:11 PM

Re: =(H32="Not available" or "Not applicable) ???

=OR(H2={"not available","not applicable"})

Posted by Barrie Davidson on November 16, 2001 1:12 PM

Use Tools|Autocorrect and add the symbols you want to use into your autocorrect list. For example when you type (c) excel automatically changes it to the copyright symbol. You can do the same for the symbols you're looking for.

Posted by Barrie Davidson on November 16, 2001 1:12 PM

Sorry, one question I missed - if the cell is not blank AND the value is greater than today, what colour?

I'm thinking you can use something like this:

1. Cell is not blank AND value is less than, or equal to today, use this formula to set your conditional format:
=AND(NOT(ISBLANK(A1)),A1<=TODAY())

2. Cell is not blank AND value is greater than today:
=AND(NOT(ISBLANK(A1)),A1>TODAY())


Can you use those formulas?
BarrieBarrie Davidson