As the conditional formating command allows only 3 formats, is it possible to
have more than 3 conditional formats using cod?
e.g. cell a1 would display red background if cell a2 = a
cell a1 would display underlined text if cell a3 = b
cell a1 would display bold text if cell a4 = c
cell a1 would display bold italic text if cell a5 = d etc.

Thanks in advance of any help
John