|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!