Conditional Formatting - Due Date Within 3 Days and Not Processed

[GIJosh316]

Hi Everyone,

I'm stumped on a certain conditional formatting that I need for a MS Excel 2003 document that I'm working on.

Basically in column A I have a list of due dates that I want to turn red when today's date is within 3 days (prior not post) of that date. Another twist on this that I need though is for the conditional formatting to take note of column B as well. Column B is where I enter the date I processed. If anything is in a cell in column B, I need the corresponding cell in column A to NOT turn red anymore.

So, for example. Cell A1 has a date of June 29 and today's date is June 27 meaning in 2 days it will be due. I need cell A1 to turn red until I enter a date into cell B1. I hope that I explained this well but correct me if I did not.

Thank you all for any help you can offer. I think this is much easier than I'm making it.

 

[Vidar]

Hi, thank you for good explanation
Hope this formula will do what you want:
=AND(TODAY()-A1<4,B1="")

 

[GIJosh316]

Hi, thank you for good explanation
Hope this formula will do what you want:
=AND(TODAY()-A1<4,B1="")

Hi Vidar,

Thank you for the speedy reply! I didn't explain myself so well after all LOL! What I should have said is that I need any dates in A1 to highlight if they are 3 days from now or prior UNLESS cell B1 has something. In any case, that last part of the formula that you posted was the key I needed and the first part of your formula with a little tweaking worked!

Here is the final formula for my conditional formatting that achieved what I needed it to do: =AND(TODAY()>A2-4,B2="")