I want to use Conditional Formatting to change the row color at each change
in a value. In the same way sub-totals work. For example, at each change in
the EE ID it would change the row high-lighting.

EE ID LAST NAME
003461 CARSON
003462 SMITH
029800 JONES
004590 HOWARD
004590 HOWARD
029925 BALDWIN
010767 KELLY
010767 KELLY
010767 KELLY
024323 ROBINS
027205 EDWARDS