Conditional Formatting with if statement

  • Thread starter Thread starter stoz
  • Start date Start date
S

stoz

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.
 
Select A2 then Format

CF>Formula is: =B2=""

Select red font and OK.


Gord Dibben MS Excel MVP
 
Back
Top