ExcelBanter - Highlight date nearest to TODAY()

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Highlight date nearest to TODAY() (https://www.excelbanter.com/excel-discussion-misc-queries/259094-highlight-date-nearest-today.html)

Colin Hayes

Highlight date nearest to TODAY()

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

Highlight date nearest to TODAY()

see your other post

--
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

All times are GMT +1. The time now is 07:07 PM.