May 18 2022 04:07 AM
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
GiantLegume