highlight cell if date is prior to todays date

MWhiteDesigns

Well-known Member
Joined
Nov 17, 2010
Messages
646
Office Version
  1. 2016
Platform
  1. Windows
I want to highlight a cell if the date is before todays date.

Cell M3 contains a due date, when it passes the date it needs to turn red. I'm using the code below but it highlights the whole column. I'd like it to leave everything untouched until the date is passed.
Code:
=$M$3<TODAY()< p> < TODAY()
<TODAY()[ p CODE]<>
 
Last edited:

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
I want to highlight a cell if the date is before todays date.

Cell M3 contains a due date, when it passes the date it needs to turn red. I'm using the code below but nothing happens. What am i doing wrong?

Code:
=$M$3>TODAY()

I think you want a < instead of a >

?
 
Upvote 0
If it highlights the whole column, the cond formatting must be set to do that?

If you click on manage rules, what does it say under "applies to"?
 
Upvote 0
If it highlights the whole column, the cond formatting must be set to do that?

If you click on manage rules, what does it say under "applies to"?

Hm, so i tried a new fomula.

Id like to have the cell M3 (due date) , highlighted in red if it passes todays date. In addition if there is a date in N3( completion date) it does not highlight anything.

i thought this might do it. its not working either.

Code:
=AND(TODAY()>M3,N3="")
 
Upvote 0
Got your <>'s mixed up again? :)

Edit - maybe not.....................
 
Upvote 0
Got your <>'s mixed up again? :)

Edit - maybe not.....................

I didn't think i did this time,

as i thought it read,

if Todays date is greater than the value in m2, and n2 is blank...format accordingly (red) ? :(
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,288
Members
448,563
Latest member
MushtaqAli

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top