Conditional Formatting on a line of data

[David_S_Walker]

Hello,

I would appreciate some assistance on the attached file.

In column K there is 3 status statements and I know I can conditionally format that cell dependent on what is selected but what I want to do is when I select "Cancelled" in K2 I want to turn the whole line from A - J inclusive red (Background) and insert bold white text saying "Cancelled in each of the cells. I think I need a macro or some VB code but my efforts thus far have drawn a blank

Help anyone?

Best regards,

David