Multi format conditional formating

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
 
B

Bob Phillips

I gave you an example in your previous post on this subject.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top