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)


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.



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



0 Replies