Highlight date nearest to TODAY()
OK, but you didn't answer my question.
If these were your dates:
15/3/2010
17/3/2010
And today was 16/3/2010
Which is the nearest date?
Both of the dates are an equal difference from the target date. So which is
the nearest date?
--
Biff
Microsoft Excel MVP
"Colin Hayes" wrote in message
...
In article , T. Valko
writes
Define nearest.
If these were your dates:
15/3/2010
17/3/2010
And today was 16/3/2010
Which is the nearest date?
HI
Thanks for getting back.
All the dates are a month apart in my example. So I guess could Today ()
versus the given date could be set to plus or minus 16.
That would probably do the trick , but I can't think my way through the
formula to enter into the conditional formatting interface.
Thanks for your help.
|