Date Format not playing nice with Conditional Formatting

[DeaninGA]

This Date Format "2021-03-01"comes out of a report we get from our ERP When I flip it into a pivot table and apply some basic conditional formatting based on the date it doesn't want to work. Whats the practical solution? Is there a way to either Reformat the date in my data table, or a way to tame Conditional formatting? My Conditional Formatting syntax is "=$G$2=TODAY()-1" for yesterday. I should Say that I have A format for yesterday, Today , 3 days in the future , and 10 days or greater in the future.


Thanks in advance
Dean

 

[Dave Patton]

Coerce the text to be a real date. N.B. See the example below.
G2 is Text.

T202103a.xlsm
	G	H	I
1		info
2	2021-03-01	FALSE	TRUE
3	01-03-21	FALSE	TRUE
4
3c

Cell Formulas
Range	Formula
H2:H3	H2	=$G$2=TODAY()-1
I2	I2	=--G2<TODAY()
I3	I3	=G3<TODAY()

 

[Dave Patton]

Today is March 18. I edited your information for this post.

T202103a.xlsm
	F	G	H	I	J
2	G2 Text	2021-03-17	FALSE	TRUE	TRUE
3	G3 Number	2021-03-17	TRUE	TRUE	TRUE
1b

Cell Formulas
Range	Formula
H2	H2	=$G$2=TODAY()-1
I2:I3	I2	=--$G$2=TODAY()-1
J2:J3	J2	=G2+0=TODAY()-1
H3	H3	=G3=TODAY()-1