I have a sheet, e.g. a1:h100. Is it possible to have more than 3 conditional
formats using code as per the example below?

cells a1:h1 would display red background if cell f1 = a
cell a1:h1 would display red background, bold text if cell f1 = b
cell a1:h1 would display blue underlined text if cell f1 = c
cell a1:h1 would display blue background with bold text if cell f2 = d
cell a1:h1 would display bold italic text if cell f1 = e
cell a2:h2 would display red background if cell f2 = a
cell a2:h2 would display red background, bold text if cell f2 = b
cell a2:h2 would display blue underlined text if cell f2 = c
cell a2:h2 would display blue background with bold text if cell f2 = d
cell a2:h2 would display bold italic text if cell f2 = e
and so on

Also would this code work on new rows if rows were inserted into a sheet
after the code has been inserted?

Thanks in advance of any help
John