Highlight date nearest to TODAY()

[Colin Hayes]

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

 

[T. Valko]

Define nearest.

If these were your dates:

15/3/2010
17/3/2010

And today was 16/3/2010

Which is the nearest date?

 

[Colin Hayes]

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.

 

[Teethless mama]

Assuming your data is sort in ascending order

Conditional Formatting:

=$A1=INDEX($A$1:$A$6,MATCH(TODAY(),$A$1:$A$6))

 

[T. Valko]

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?