B Boenerge Mar 30, 2008 #1 How do I get the fonts in a spreadsheet to change colour two months before the date inserted. Thanks in adavnce Jason
How do I get the fonts in a spreadsheet to change colour two months before the date inserted. Thanks in adavnce Jason
B Bob Phillips Mar 30, 2008 #2 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)
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)
B Boenerge Mar 30, 2008 #3 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
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
B Bob Phillips Mar 30, 2008 #4 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)
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)
