Highlight date nearest to TODAY()
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.
|