Change Font Color on Dates

[Stacey1016]

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

 

[Roger Govier]

Hi Stacey
Select the range of cell in column B
Format>Conditional Formatting>Formula Is
=B1-A1<date(year(a1),Month(a1)+1,day(a1))
Format>Font>Red