Previous Topic Next Topic

Conditional formatting before color sorting!

Solved/Closed
Carman - Jul 22, 2010 at 01:45 AM
 carman - Jul 25, 2010 at 10:16 PM
Hello,
I used conditonal formatting to select and color some data, and now i want to apply color sorting to rearrange the data.

However, it seems like excel can no longer detect the color after i use conditional formatting. I tried several codes that i could find in google but none of them worked. Does that mean color sorting cannot be used if i use conditional formatting?What other method can i sort the data by color ( i just got 2 color to sort!)?

Thanks.
Related:

1 response

Answer 1 / 1
Blocked Profile
Jul 22, 2010 at 02:26 AM
Dear Carman,

Please provide clear information about which application you are talking about for us to be able to help you about it.

Thank you.
Carman
Jul 22, 2010 at 02:56 AM
I am sorry.. i am talking about Excel, VBA scripts is what i am looking for to complete the task.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 22, 2010 at 02:50 PM
Only way i can think of that you put a column that will be based on formula of your conditional format. Then you can use the sort.
If you go by this method, then I would suggest, dont use the formula in both places. Have the conditional format based on this newly added column
carman
Jul 25, 2010 at 10:16 PM
It works! Thanks!

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Why is my Whatsapp Chat not sorted chronologically?
Kingtt -
Yeraldocaleb -

15 responses