If you need to do this while using Excel online too, VBA will not be an option. A slightly easier manual option would be to filter one column by each colour in turn, then populate all visible cells with the relevant values. Repeat for each column.