View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stoz stoz is offline
external usenet poster
 
Posts: 3
Default 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.