ISBLANK question conditional formatting

[LordEvil]

Hi, I have a lot of dates from D3:D54. I would like to set up conditional formatting to show them red if they are past due. How can I make the blank cells not show any color format?

I must be close but am just missing something. I've tried searching with no luck.

ISBLANK(D3,"")=IF(D3<TODAY()) This doesn't work

 

[jtakw]

Hi,

Start at D3 and select your range (I.e. D3:D54), CF, use formula, enter:

=AND(D3<>"",D3< TODAY())

Format Fill/Font as desired.

 

[DanteAmor]

Try this:

=AND(D3<>"",D3 < here your date)


defeated

 

[LordEvil]

Thanks guys, that worked. I will have to read up on the AND function.

 

[Aryatect]

Hi,

below can be an option :

=AND($D3 <> "",$D3 < TODAY())<today())<today())< html=""></today())<today())<>

 

[jtakw]

You're welcome.

 

[DanteAmor]

Thanks guys, that worked. I will have to read up on the AND function.

A detail, in the condition format you should not put the IF statement.
If the formula is true, then the cell lights up.

=AND(D3<>"",D3< TODAY())

In the previous example, if the 2 conditions are met, it is true.