Solved 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

Report •

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

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

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question