Conditional Formatting in Excel when data changes

Joined
Aug 29, 2012
Messages
1
Reaction score
0
Hi trying to set up conditional formatting.

Column has about 8 instances of one name then changes to another name.
I want to shade every other name, all eight(sometimes 9) rows.

any ideas?
 
Back
Top