Solved Excel Conditional Formatting Dates

October 16, 2013 at 09:12:48
Specs: Windows 9
Hello -

I've been spending most of the day trying to figure out a solution and seem to get further and further away. I have 2 columns. The first column contains a date for delivery (P5) the second column shows a forecased date for delivery (Q5). I need to create a formula that will change the color of the Column Q cell for the following: if it is equal to or less than column P it will be green. If 1-14 days past column P it will be yellow and more than 2 weeks past the column P date, the cell will be red.

I hope I explained that well, but if anyone can help it would be much appreciated!

See More: Excel Conditional Formatting Dates

Report •

October 16, 2013 at 10:03:49
✔ Best Answer

Report •
Related Solutions

Ask Question