change color if more than a year old

  • Thread starter Thread starter Steph
  • Start date Start date
S

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!
 
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.
 
You rock, thanks!!!

JLatham said:
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 said:
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!
Click to expand...
Click to expand...
 
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.
 
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.
 
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
 
awesome, thank you all!

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

=$A$1<TODAY()-365

Steph;643837 said:
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!
Click to expand...


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

.
Click to expand...
 
Back
Top