Excel formula query

QuestionEdit

Good Day, I am using2003 version (on an oil rig offshore Egypt, so don't laugh please) I would like to know what formula to use if I would like to change the color of text in a cell by adding a formula if the date in the cell is within a 6 months range. Your help would be greatly appreciated.

AnswerEdit

use conditional formatting, set that to a formula and (for simplicity) 182 days as 6 months - I'm not clear if your range is 6 months before, 6 months after, 3 months either side etc, but some formula like

=A2-182 >now()

would return dates occuring up to 6 months in the future - modifying this test using Now() or Today() will enable you to alter the condition. I tend to use NOW rather than TODAY simply because there is less to type!