change color if more than a year old

[Steph]

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!

 

[JLatham]

Assuming the cell(s) actually have a date in them and not plain text, use
Conditional Formatting. Select the cells then Format-->Conditional
Formating...
use the 'Cell Value Is' option along with "less than" and enter
Now()-365 into the 3rd entry area. Click [Format...] and set the font
properties to Bold and Red.

 

[Steph]

You rock, thanks!!!

Assuming the cell(s) actually have a date in them and not plain text, use
Conditional Formatting. Select the cells then Format-->Conditional
Formating...
use the 'Cell Value Is' option along with "less than" and enter
Now()-365 into the 3rd entry area. Click [Format...] and set the font
properties to Bold and Red.

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]

That can be done in conditional formatting, use this formula but adjus
the cell addres

=$A$1<TODAY()-36

Hi All, what is the easiest way to accomplish this? Basically if a dat
i
more than a year old, i want it bolded and red

Thanks

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[JLatham]

Oddly, the formula I came up with didn't work! I had to change the formula to:

DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-365
to get it to act properly in the conditional formatting.

 

[Steph]

actually, now that I checked it, it's not working for me either way! It
stays red and bold regardless of date.

Thanks for any help.

 

[Peter T]

Another one

In A1 enter
=TODAY()-365

For the CF
Cell value is, less than, =$A$1

or Name a formula
Name: LastYear
Refersto: =TODAY()-365
(go back make sure quotes didn't get included)

Cell value is, less than, =LastYear

Regards,
Peter T

 

[Steph]

awesome, thank you all!

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

=$A$1<TODAY()-365

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/showthread.php?t=179376

Microsoft Office Help

.