Conditional Formatting - Formula

[ChrisFoster]

Hi all,

I have a list of dates in column T, some cells are blank however. What I need is a formula to use in conditional formatting to allow me to highlight cells where the date in the cell is in the past from today's date (I'm not interested in dates in the future or today).

Please help.

 

[IamBatman]

You can use the "format only cells that contain" option, then leave the first drop down as "cell value", but change the second to "Less than" and put =today() in the box

Then format it

 

[Marcílio_Lobão]

ChrisFoster, Good afternoon.

Select the cells desired at column T

Conditional Format >> Formula >> type: =$T1 < TODAY() >> ok

Tell us if it worked for you as desired.
I hope it helps.

 

[Joe4]

ChrisFoster, Good afternoon.

Select the cells desired at column T

Conditional Format >> Formula >> type: =$T1 < TODAY() >> ok

Tell us if it worked for you as desired.
I hope it helps.

I think if you do not want to format the blanks (like their question seems to suggest), then if you want to use a formula approach, you may need to amend the Conditional Formatting formula to:

=AND($T1<TODAY(),$T1>0)

 

[ChrisFoster]

I think if you do not want to format the blanks (like their question seems to suggest), then if you want to use a formula approach, you may need to amend the Conditional Formatting formula to:

=AND($T1<TODAY(),$T1>0)

Thanks for everyone's suggestions - this is the only one that has worked as I'd need it. Thanks again.

 

[Joe4]

You are welcome.
Glad we could help!