Conditional format to highlight future dates

[still learning]

Hi,

What I’m I doing wrong??????

I have a column that contains past, present, and future dates. They are formatted as mm/d/yy the dates are in F72:F85. F86:F200 are blank for now but will have dates in them as the year goes on.
I’m trying to use conditional format to highlight in red any cell in the column that is equal to or greater than today. I can’t see what I’m doing wrong
I tried using this

=F72>=today()

And highlighting F72:F200
F85 contains 9/17/24
Nothing changed color
I then put in cell F1

=today()

And changed the formula in CD to

=$F$1>=today()

And highlighted F72:F200
Nothing changed color
I tried without the “>” only the “=”…I also tried “<”
Still no change

I then put this formula in a cell near by and got “red” as a result

=if(f85>=S1,”red”,”blk”)

What am I missing??????

mike

 

[Joe4]

Make sure you follow these steps:
1. First select the range: F72:F200
2. Go to Conditional Formatting and enter the Conditional Formatting formula:

=F72>=Today()

3. Choose your formatting option
4. Click OK

Note that the formula in step 2 absolutely MUST coincide with the FIRST cell in your selected range in step 1 (you MUST select this range before applying the formula).
People often make the mistake of selecting the whole column, but then writing the formula on the first cell that they want to apply it to. That will not work.
You must first select the EXACT range you want to apply it to, and write the formula as it pertains to the very first cell in your pre-selected range.

 

[still learning]

Hi Peter
thank you. I think what i was doing wrong was not highlighting the range first.

Mike

 

[Joe4]

You are welcome.
Glad I was able to help!