Workbook1.xlsx

I currently have 2 conditional formatting formulas from columns B-J. When J is overdue, columns B-J turn red. When J is coming up in the next 2 weeks, columns B-J turn orange.

Now I need columns B-J to go back to its original format and colours when a date is entered into column K. Is this also a conditional formatting? How can I do this?

Please help. Thanks.