Excel formula query

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:31 PM GMT

Question

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.

Answer

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!

Advertisement

©2021 eLuminary LLC. All rights reserved.