Conditional Formatting with if statement
 

I am trying to set up cell formatting using a combined "If or" and "If and'
statement.
My worksheet is as follows:

B C D ect
A1 Jan Feb Mar
Acct Name

Im trying to set the conditional format to show the account name (A2) in
red if a date has not been filled in, in B2.

In other words If B1=Jan, or C1=Feb, or D1=Mar and no date has been entered
in cell B2 use red font in A2.

Any help would be appreciated.

Conditional Formatting with if statement
 

Why do you want to use an IF statement? Conditional formatting wants a
condition that returns TRUE or FALSE.
Use CF/ Formula Is/
=AND(B2="",OR(B1="Jan",C1="Feb",D1="Mar"))
Choose your coloured format.
--
David Biddulph

"stoz" wrote in message
...
I am trying to set up cell formatting using a combined "If or" and "If and'
statement.
My worksheet is as follows:

B C D ect
A1 Jan Feb Mar
Acct Name

Im trying to set the conditional format to show the account name (A2) in
red if a date has not been filled in, in B2.

In other words If B1=Jan, or C1=Feb, or D1=Mar and no date has been
entered
in cell B2 use red font in A2.

Any help would be appreciated.

Conditional Formatting with if statement
 

Select A2 then Format

CFFormula is: =B2=""

Select red font and OK.


Gord Dibben MS Excel MVP

On Wed, 7 Oct 2009 12:26:01 -0700, stoz
wrote:

I am trying to set up cell formatting using a combined "If or" and "If and'
statement.
My worksheet is as follows:

B C D ect
A1 Jan Feb Mar
Acct Name

Im trying to set the conditional format to show the account name (A2) in
red if a date has not been filled in, in B2.

In other words If B1=Jan, or C1=Feb, or D1=Mar and no date has been entered
in cell B2 use red font in A2.

Any help would be appreciated.