Change formatting of rows when value changes in column

[bjohnsonac]

I have a spreadsheet where one column will determine the color of the entire row....if the sales persons name in column B = "Dew", the entire row should be shaded light blue. if the name is "Swiger" they should be white, when its Webb, it should be light blue again- alternatively, at every change in value in that column, alternate the entire rows shade - when the sales person name changes from Dew to Swiger, change the shading of Swigers Rows to white, when it changes from Swiger to Webb, make Webb's rows shaded the same blue as Dew's row's were....there are multiple rows for each sales person. Anyone have any ideas?

[zbor]

Conditional formating -> Formula is -> IF($B$2=...) etc

[teylyn]

sorry zbor, but there are several things wrong with your reply

The above formula has an absolute reference to $B$2, so it cannot be copied to another row. Take out the $ sign before the 2, then the formula will work for all rows.

Conditional formating -> Formula is -> IF($B2="Joe"...) etc

Further, you don't need an IF statement, just a statement that will return True or False for the condition. It is perfectly OK for the condition to be

=$B2="Joe"


Bjonsonac:
Please keep in mind that with Excel 2003 you can only achieve 4 different colours: 1 as the default and three more with conditional formatting. So, if both Joe's and Jane's rows should have the same color, your condition could look like

Conditional formating -> Formula is -> =OR($B2="Joe",$B2="Jane")

This leaves you some room for more names.

Hope that helps

[bjohnsonac]

Thank you! Thank worked perfectly:D