highlight font by date

[Guest]

-Hello,

Is there a way to highlight font and type for a cell by a date criteria? For
instance, if a date is within 3 days of the current system date I want the
date bolded in red 14pt font. I also want to use green and yellow colors to
indicate other proximities of date to current system date. I think I might be
able to use conditional formatting for this but not sure how.

Thanks,
Nelly

 

[Tim]

You can use conditional formatting and set the "formula" option to something
like this (where the value is in E12)

=E12>(TODAY()-3)

Tim

 

[matt]

-Hello,

Is there a way to highlight font and type for a cell by a date criteria? For
instance, if a date is within 3 days of the current system date I want the
date bolded in red 14pt font. I also want to use green and yellow colors to
indicate other proximities of date to current system date. I think I might be
able to use conditional formatting for this but not sure how.

Thanks,
Nelly

Here's one possible way.

Create a cell that has your system date. Let's say 4/27/07 is in A1.
Then use two more cells, one to be 3 days above A1 and 3 days below
A1. So, in A1 you have 4/27/07, in A2 you have =A1+3 (or 4/30/07),
and in A3 you have =A1-3 (or 4/24/07). Then select the dates you want
to compare to A2 and A3, go to Menu Bar: Format/Conditional
Formatting..., and setup your condition. (i.e. Cell Value Is;
between; A2; and A3; select the "Format..." button and select your
"Font style:" and "Color:").

Note: You can add up to 3 conditions with conditional formatting.

Matt