Conditional Formatting with if statement

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.
 
D

David Biddulph

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.
 
G

Gord Dibben

Select A2 then Format

CF>Formula is: =B2=""

Select red font and OK.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting with dates 7
VBA Coding Help for Beginner 0
Retrieve VLOOKUP results based upon a conditional statement 5
Excel Conditional Formatting for Percentagrs 0
Conditional Formatting Training Expiry Dates 2
Cumulative formula for word table 0
Conditional Formatting assistance 7
Conditional formatting with two columns 0

Top