hi Matt,

select the range go to |FORMAT|CONDITIONAL FORMAT| change to the Formula is
and use

=a1<=today()

format as your needs

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Matt D Francis" escreveu:

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