Format cell colour within table sorted using slicer tools

Occasional Visitor

Hello all, I would like to format full table rows based on the text in column D after the table has been sorted using a slicer tool filtering on column C. 

 

In image 1 is the formatting I would like for the output (this has been manually formatted to show the different desired colours)

GiantLegume_0-1652871872894.png

In image 2 is the problem, when filtered by column c (haulier) cells with the same colour end up 'next' to each other removing the clear delineation between sites.

GiantLegume_1-1652871952451.png

 

Is the formatting that I want to do possible? It seems like it should be but currently I cannot make it do what I want.

 

I can provide the spreadsheet if that would help anyone.

 

Many thanks

 

GiantLegume

0 Replies