Conditional formatting issues 2.0

Cameltoe

Board Regular
Joined
Jun 5, 2018
Messages
175
Hi,

Please see screenshot:
https://imgur.com/WEnzwsS

I have so many issues with this condiational formatting, now I am facing this. Everything looks perfectly correct to me but the conditional formatting still colors the cell, why?
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,392
Office Version
365
Platform
Windows
What value do you actually have in the cell?
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,392
Office Version
365
Platform
Windows
The TEXT function returns a string, you can't properly compare a string value to a date value.
 

Cameltoe

Board Regular
Joined
Jun 5, 2018
Messages
175
Any suggestions? I've also tried:
=$E$19<(YEAR(TODAY())&MONTH(TODAY())) but does not work.
 
Last edited:

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
3,979
Office Version
365, 2019, 2016
Platform
Windows
try

=(YEAR($E$19)+MONTH($E$19))<(YEAR(TODAY())+MONTH(TODAY()))
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,429
Office Version
365
Platform
Windows
Maybe
=$E$19<=EOMONTH(TODAY(),-1)
 

Forum statistics

Threads
1,084,819
Messages
5,380,090
Members
401,645
Latest member
Me22

Some videos you may like

This Week's Hot Topics

Top