Doug Jefferson
Board Regular
- Joined
- Nov 4, 2010
- Messages
- 60
In Excel 2007 I would like to sort data based on the color assigned in conditional formating.
Apple 25 Location 1
Peach 30 Location 2
Grape 18 Location 1
Apple 29 Location 2
Olive 15 Location 3
Grape 10 Location 2
For example Apple and Grape are highlighted in green since they are duplicates and also have them sorted by units and or locations and I would like them at the top of the list followed by the remainder of the items
Apple 25 Location 1
Peach 30 Location 2
Grape 18 Location 1
Apple 29 Location 2
Olive 15 Location 3
Grape 10 Location 2
For example Apple and Grape are highlighted in green since they are duplicates and also have them sorted by units and or locations and I would like them at the top of the list followed by the remainder of the items
