Conditional Formatting for Forecasting Dates

[Creospan]

Hello! I am JT.

I have Windows 8 using Microsoft Excel 2010

I am trying to use Conditional Formatting to forecast dates in Column A based upon the blanks in Column B to do (3) things:

1. Trying to get the dates in Column A to turn red when the dates in Column B is blank and is over 31 days over the date in Column A. For example, 11/10/2014 would be red because there is a blank in Column B and is glaringly over 31 days from 11/10/2014.
2. Trying to get the dates in Column A to turn yellow when Column B is blank and is within 30 days of the date in Column A.
3. Trying to get the dates in Column A to turn blue when Column B is blank and is within 14 days of the date in Column A.

I would appreciate specifics on what the formula would look to make this happen, if possible.

Thank you.

Column A Column B
ETA	Actual
4/13/2015	4/2/2015
11/10/2014
5/4/2015	5/18/2015
4/4/2015	3/23/2015

<tbody>
</tbody>

 

[MarcelBeug]

How can a blank be within 30 days of a date? I guess you mean non-blank?

If so then the formulas for the rules in cell A2 are in this order (red, blue, yellow):

=ABS(A2-B2)>31
=ABS(A2-B2)<=14
=ABS(A2-B2)<=30

This assumes difference between A and B, no matter which one is earlier.

 

[Creospan]

MarcelBeug:

Thank you for your timely response.

Hey! I only ask the questions in the way my team provides it. But to elaborate. The team only wants to track the blank spaces in Column B and to determine how long they have been blank in reference to Column A's date. Hope that makes better sense. My first time out. I'll give your input a try. Thanks for being there.

JT