Highlight date nearest to TODAY()
Define nearest.
If these were your dates:
15/3/2010
17/3/2010
And today was 16/3/2010
Which is the nearest date?
--
Biff
Microsoft Excel MVP
"Colin Hayes" wrote in message
...
Hi
I have dates in a column in this format :
16/01/2010
16/02/2010
16/03/2010
16/04/2010
16/05/2010
16/06/2010
I'm trying to set the conditional formatting so that the nearest date to
today is in bold.
Can someone help with this?
Grateful for any advice.
Best Wishes
|