Apply conditional formatting to column A when date is entered in column B (adjacent cells)

[HedyES]

I have a spreadsheet that has three conditional formatting rules, and I would like to add a fourth/final rule as follows:

When a date is entered into a cell in column B, the adjacent cell in column A should go from a red, orange or yellow background to white/no background.

To explain, there projects being entered into this spreadsheet with the target completion dates column A. Column A is conditionally formatted based on the date from "TODAY" as either red, orange or yellow, depending on its proximity to today's date/the date that the spreadsheet is opened.

However, once the project is complete, the user enters the date it is completed, and the formatting in column A should then automatically return to a white background.

I am having trouble figuring out how to format this. Thank you

 

[Special-K99]

You need to specify the proximity

 

[Special-K99]

"However, once the project is complete, the user enters the date it is completed"

Enters it where? Into column B ? If its column B how will Excel know that date is actually a completion date and not a normal date?

Not enough info to solve this.

 

[HedyES]

The list of projects could be several hundred rows - one row per project. Examples:

Project 1 has a completion target date of 12/12/2017 in cell A2
A project manager entered a completed date of 12/1/2017 in B2 (in this example the completion date is prior to the target date)

Project 2 has a completion target date of 1/3/2018 in cell A3
A project manager entered a completed date of 1/10/2018 in cell B3

Once the completed dates are entered into column B (whatever cell for the project), then the conditionally formatting should change from it being either red, orange or yellow to white or no background color.

Does this help?