Thread: How can i sort data according to the color of the background?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl John Michl is offline
external usenet poster
  
Posts: 81
Default How can i sort data according to the color of the background?
You'll need a macro to do this. See Chip Pearson's site at
http://www.cpearson.com/excel/SortByColor.htm .

- John Michl
www.JohnMichl.com/exceltips.htm

Nate@GM wrote:
I would like to take the rows of data that i have hilighted and move,
arrange, sort them according to their individual colors. Suggestions?

Reply With QuoteReply With Quote