Font colour

[Boenerge]

How do I get the fonts in a spreadsheet to change colour two months before
the date inserted.
Thanks in adavnce
Jason

 

[Bob Phillips]

Conditional formatting. See http://www.contextures.com/xlCondFormat01.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Boenerge]

Hi Bob,
What I don't understand is how to set the formatting so that it is two
months before the date in the cell.
Thanks
Jason

 

[Bob Phillips]

Depending upon the cells, it would be a formula of something like

=B1<=DATE(YEAR(A1),MONTH(A1)-2,DAY(A1))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)