ISBLANK question conditional formatting

LordEvil

New Member
Joined
Oct 20, 2018
Messages
16
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
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

jtakw

Well-known Member
Joined
Jun 29, 2014
Messages
5,146
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.
 
Last edited:

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,095
Office Version
2007
Platform
Windows
Try this:

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


defeated ;)
 
Last edited:

Aryatect

Active Member
Joined
Jun 17, 2019
Messages
308
Hi,

below can be an option :

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

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,095
Office Version
2007
Platform
Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,101,760
Messages
5,482,715
Members
407,359
Latest member
aaawww

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top