View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] mahadevan.swamy@gmail.com is offline
external usenet poster
 
Posts: 59
Default Sorting Colored list

Hi,

I have two columns of numbers and I have used conditional formating
such that if a number from the second column matches the one on the
first, then use a green colour for the cell for that matched number.
Now I want to sort this list in a way that I can bring all the
coloured cells together. Is there a way for that. Thanks

Mahadevan Swamy