I have a spreadsheet for a 24 hour rota, i have added drop down boxes and
want to use conditional format the options, I have 5 selections on my drop
down list but formating will only allow me to colour 3, any way around it?