change color if more than a year old
 

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!

change color if more than a year old
 

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

change color if more than a year old
 

You rock, thanks!!!

"JLatham" wrote:

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

change color if more than a year old
 

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

change color if more than a year old
 

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

change color if more than a year old
 

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.

"JLatham" wrote:

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

change color if more than a year old
 

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" wrote in message
...
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!

change color if more than a year old
 

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

.