color banding in Excel after sorting
I'm trying to color band this list for item numbers (alternate color
bands for each change in item number), but can only find simple color band formulas such as this on the web http://www.cpearson.com/excel/banding.htm Any idea how to do this with conditional formatting? Thanks for the help Item Info 1 a 1 b 1 c 1 d 2 e 2 f 2 g 2 h 3 I 3 j 3 k 3 l 3 m |
All times are GMT +1. The time now is 07:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com