Excel filters and colours

[alison1306]

Hi

I have a spreadsheet with filters in place and when I change a column to 'completed' I want the whole row to change to one colour.  How do I do this please?

[#2]

Merge the cells and then change the color.

[#3]

I need to keep the columns separate, I can't merge the cells