M
Matt D Francis
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
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