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,275
What value do you actually have in the cell?
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,275
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,826
try

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

Fluff

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

Forum statistics

Threads
1,077,985
Messages
5,337,533
Members
399,154
Latest member
gavlink

Some videos you may like

This Week's Hot Topics

Top