Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home



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


Re: Conditional Formatting - 2 conditions?

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


Re: Conditional Formatting - 2 conditions?

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

Black


Re: Conditional Formatting - 2 conditions?

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

Black


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

Posted by ren on November 16, 2001 1:06 PM
=(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)


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

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

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


Re: Conditional Formatting - 2 conditions?

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.


Re: Conditional Formatting - 2 conditions?

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




This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.