See example below. Using Excel 2010 and normally go through a report and change row color when value changes. You can see here where row color is constant until User value changes and then switches to grey and then back to white with next User change. Very useful in sending out to group and allowing individuals to know where there information starts and stops within a report.
Excel 'Format as Table' actually has similar formating but changes colors for every row rather than at value difference. Is there functionality I am missing to do color change with values or do I need to create VBA script to do this? (In that case, the solution would probably be more labor intensive than the problem).
Thanks for your help!