Conditional Format <=Today()
 

Hello

I want to apply conditional Formatting to a range of cells dependant on the
current date. All cells are formatted and populated with dates, and I simply
need them to aplly formatting based on whether the date is <= the present
date.

I've tried

Formula Is <=today()

but thinks it's text and chnages it to

Formula Is ="<=today()"

So how do I do it?

Matt