View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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