Conditional formatting dates based on another cell value

May 18, 2017 at 08:12:19
Specs: Windows 7
I have two columns of dates, and I need to apply a conditional formatting rule so that;

If a date in Column B falls within 0-3 months of the date in Column A (same row), it highlights Green
If a date in Column B falls within 3-6 months of the date in Column A (same row), it highlights Yellow
If a date in Column B falls within 6-12 months of the date in Column A (same row), it highlights Red

I have searched on a lot of forums, but cannot find anywhere. Any help very much appreciated! Thanks :)


See More: Conditional formatting dates based on another cell value

Reply ↓  Report •


#1
May 18, 2017 at 09:41:14
Try this How-To and see if it works for you:

https://www.computing.net/howtos/sh...

MIKE

http://www.skeptic.com/


Reply ↓  Report •
Related Solutions


Ask Question