See attached. Not much for real formulas were needed. Used Conditional
formatting in Excel 2007.

A1 has "=Today()"

Then I used Conditional formatting Highlight Cells Rules Between...



"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