Highlight date nearest to TODAY()

C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight date nearest to TODAY() 4
Check if a date comes before/after a range of dates 0
Find then highlight in yellow 6
Compare dates in two different ranges 1
Payroll 2
Searching for Nearest Next DateTime in VBA 9
Specific Date from a Range 3
lookup for the minimum date among different dates 3

Top