I have a worksheet (Whole sheet) and I want to make a certain value show the
cell as a certain colour i.e. if the cell value is H then I want the cell to
be red, if a cell is L then I want it to be orange etc etc..... (I have
approx 8 differnt cell values and I want a different colour for each)

Can anyone tell me the correct syntax as I can't seem to get it right!!