Excel filters and colours

Occasional Visitor

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?

1 Reply
Merge the cells and then change the color.