Excel filters and colours

New Contributor

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 Replies
Merge the cells and then change the color.
I need to keep the columns separate, I can't merge the cells