-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

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

=E12(TODAY()-3)

Tim

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

On Apr 27, 9:12 am, Nelly wrote:
-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