How to make the command button override the conditional formatting

Sales Follow up tasks.xlsm

Here is a spreadsheet I am working on to track sales tasks.

If you type a date in column J then all of the dates populate in column K:Y according to the data in row 3

Once the dates are in the spreadsheet, you can type a date in cell I2 and any dates in columns K:Y that match will turn red. This is to indicate to me what tasks are due on certain days.

I also have a command button set up so if I highlight a cell K:Y and hit the completed task command button then that cell will turn green signifying to me that the task for that date is complete.

However, the conditional formatting that turns the cells red overrides the completed task (green cell)

How can I make it so if I complete a task and turn it green then it will not change to red if I type in a due date.

Hope this makes sense!

Thank you Nate! That works!

On thing is I have an undo button in case I mark a task as complete by mistake. Obviously at that point the conditional formatting is deleted...is there a way to write in the undo button code to have the conditional formatting come back?

Here is the code for the button

Please Login or Register  to view this content.

This is the current conditional formatting:

=AND(K5<>"", NOT(ISERROR(MATCH(K5,$I$2,0))))

Thanks so much for your help!