Change Font Color on Dates
 

Hi Everyone...
I need some help please... Can I make this worK? If on A1 is the current
date and on B1 is the due date, can B1 change font color to red if it is less
than a month from now? I am making a reminder or tracking sheet and I need to
be informed if the due date is less than a month away...Thank you for your
help..
--
Stacey

Change Font Color on Dates
 

Hi Stacey
Select the range of cell in column B
FormatConditional FormattingFormula Is
=B1-A1<date(year(a1),Month(a1)+1,day(a1))
FormatFontRed
--
Regards
Roger Govier

"Stacey1016" wrote in message
...
Hi Everyone...
I need some help please... Can I make this worK? If on A1 is the current
date and on B1 is the due date, can B1 change font color to red if it is
less
than a month from now? I am making a reminder or tracking sheet and I need
to
be informed if the due date is less than a month away...Thank you for your
help..
--
Stacey