awesome, thank you all!

"Simon Lloyd" wrote:


That can be done in conditional formatting, use this formula but adjust
the cell address

=$A$1<TODAY()-365

Steph;643837 Wrote:
Hi All, what is the easiest way to accomplish this? Basically if a date
is
more than a year old, i want it bolded and red.

Thanks!


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=179376

Microsoft Office Help

.