I have a project excel sheet . On the sheet in a column (Column D) it has the date when the task was last worked. If it hasn't been worked for 2 days I have a conditional rule turn the cell red. It this gives a visual that it requires to be prioritised. If it has been worked within two days then the date shows the date last worked and so long as it gets works within 2 days the cell has another rule that turns the cell green. All this works OK however in another column lets say column H I have where the task is upto, ie beginning, in progress or complete.

Once a task has been completed then we don't need to work it so the date in last work doesn't get amended resulting in the cell colour turning red giving a visual that the task needs to be prioritised.

So the question is there another rule I can put in that as soon as the cell in Column H says Completed it keeps the cell colour green and stops working the over 2 day rule - which turns the cell?

Thanks for any help in advance.