I want to change the colour of cells A1:G1 if the value of G1 is K (make the
row green), U (make the row amber) or S (make the row red). Really want this
to apply to each row below as the relevant G value is input.
Does that make sense?