Conditional Formating using dates

  • Thread starter Thread starter John Pitchford
  • Start date Start date
J

John Pitchford

I keep a spreadsheet with an array of dates that I would like to
compare to the current date for conditional cell formatting. Trouble
is I cannot figure out how to do it. Should I use "Cell value is"
method, or "formula is" method. And the input interface when setting
up the conditions does not seem to accept a cell reference ie. "cell
value is greater than A1" A1 being the current date.
ANY HELP WOULD BE APPRECIATED !
Thanks
John Pitchford
 
John,

Use Formula Is

Assume the array is A1:A10, and use a formula of
=A1=TODAY()
=A1<TODAY()
=A1>TODAY()
or whatever is appropriate

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You can use either

cell value is greater than =$A$1

or

cell value is greater than =TODAY()

the formula is gives a bit more flexibility
but you need to refer the cell where you want the format

=B1>TODAY()

then if you select the whole range using the above it will adapt accordingly
and change the reference so if you select B1:B5 in B5 it will look like

=B>TODAY()

That works for cell value too
 
Back
Top