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.