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.