Conditional formatting issues 2.0

Cameltoe

Board Regular
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
The TEXT function returns a string, you can't properly compare a string value to a date value.
 

Cameltoe

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

Some videos you may like

This Week's Hot Topics

Top