View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Louise
 
Posts: n/a
Default sorting data by colour?

I have a worksheet which contains various shaded rows, depending on what they
contain.

I know I can sort data in alphabetical order, however, is there any way I
can ask Excel to sort the information by colour? For example, all yellow
rows together, then green, then pink etc?

Thank you.
Louise