Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Colored list
In Excel 2007 yes, in previous versions use a help column/row and tag the
help column with the same criteria you used in your conditional formatting then sort by the help column. The only other option is VBA code -- Regards, Peo Sjoblom wrote in message oups.com... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Colored list
Ok. Atleast how do I match the numbers from the second column to the
ones in the first column and perform an easy sorting to check which numbers are matching and which is not? Thanks Swamy On Apr 26, 1:38 pm, "Peo Sjoblom" wrote: In Excel 2007 yes, in previous versions use a help column/row and tag the help column with the same criteria you used in your conditional formatting then sort by the help column. The only other option is VBA code -- Regards, Peo Sjoblom wrote in message oups.com... 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 colouredcellstogether. Is there a way for that. Thanks Mahadevan Swamy- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting a list | Excel Discussion (Misc queries) | |||
Colored dropdown list | Excel Discussion (Misc queries) | |||
Sorting a List | Excel Discussion (Misc queries) | |||
sorting a list | Excel Discussion (Misc queries) | |||
Sorting a list | New Users to Excel |