Automated row coloring macro (based on value of a particular cell)

[medwardnfriends]

I need rows to automatically fill with a particular color based on the value of the cell in column V of that row. So if cell V10 says for example: "John", the entire row 10 will become blue. If it says "Mike", row 10 will become green, etc. There are four possible names and corresponding colors, which are listed in cells A121 to A124. Is there a macro or other function that will allow me to do this? Thank you in advance.

 

[VoG]

Try Conditional Formatting http://www.contextures.com/xlCondFormat02.html

 

[asking]

Hi,

You need 4 rules one for each name ~
Select row 10 then conditional format, new rule, use a formula...
Rule 1 =$V$10="John" Format Blue. then select new rules and do the same for the other names and click apply.

 

[medwardnfriends]

Thank you that works. However, i have 120 rows of data, do I need to repeat this process of making 4 rules for every row? or can i highlight all the rows and change the formula slightly to make this work?

 

[VoG]

Highlight all the rows, then enter the CF formulas referring to the top row in your selection. Excel will adjust the formulas for the lower rows automatically.

N.B the formula would need to be like this

Rule 1 =$V10="John"

(No $ before the 10)