Conditional Formatting/VBA/User Defined Function for Cell Color

[rqcwamboy]

I have a spreadsheet that has conditional formatting where I track insurance expiration dates.
If the cell is blank it is yellow
If the date in the cell is current it is blank
If the date in the cell expires within 30 days it is orange
If the date in the cell is expired now it is red

Now sometimes these contractors are finished with the project, so we will change their other cells a light orange to indicate they are no longer on the project.

However, the insurance cells keep tracking via the conditional formatting, and I get red cells, but the insurance is no longer needed.

What I would like to do is when I turn the other cells (they are adjacent to the insurance) the light orange for the insurance cells to have no fill and the conditional formatting to stop.

I have never done VBA or User Defined Function before. How do I do this?

 

[Rick Rothstein]

Now sometimes these contractors are finished with the project, so we will change their other cells a light orange to indicate they are no longer on the project.

However, the insurance cells keep tracking via the conditional formatting, and I get red cells, but the insurance is no longer needed.

What I would like to do is when I turn the other cells (they are adjacent to the insurance) the light orange for the insurance cells to have no fill and the conditional formatting to stop.

You might not need VBA... do you have, or could you add, as cell per row that is an indicator when the project is finished (say an X if finished)? If so, you can make your insurance cell's primary conditional formatting condition check that column's cell first and color the itself orange if there is an X.

 

[rqcwamboy]

I don't and I am not sure if I can because this is a company standard form, but that is something I am looking into