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