Conditional formatting of adjacent cells from a drop down list

Hello,

In one column I have a drop down list of a dozen different initials with conditional formatting on those cells. I would also like to conditionally format an adjacent text string column based on those initials, but don't want to set up a dozen rules on each cell, one by one. If I set up the top cell with the correct rules I cannot fill the formatting in because the formula is not updated on a row by row basis, but en bloc for the range.

I have no real experience with VBA or macro's, is there a way to do this more elegantly than brute force?

Thank you very much in advance. This forum has always been a great help, hopefully you can help this, too!

Hi jeversf, thanks for replying.

I've made up a quick mini file of what I am talking about, sorry for not making it up before.

So I have a column of initials of people responsible, and want to make the "actions" column they are responsible for conditional on the initials as well. Unless I'm being thick I don't know a way to set up one rule, or a small number of rules, to get it done.

I hope all of this makes sense.

Thanks!

I ending up sorting it out. I set up my anchoring incorrectly, I tried copying it over and it didn't work so I moved on. Fixing what is absolute and what is relative made everything work, so it was a a straightforward copying over my formatting to the cells I wanted. Thanks!