J
John Davies
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
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