Hi, I have a spreadsheet with a column containing drop down cells (data>validation>list). Each cell has the same 6 options and I would like to autoformat the cell depending on the option chosen.

It is working fine using conditional formatting to shade the cell but it only allows me three options, so i can only autoformat when 3 of the options are chosen but cannot do the same for the other 3.

Any help appreciated