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.
-1
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.
0
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
0
carman
Jul 25, 2010 at 10:16 PM
It works! Thanks!
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

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

26 responses
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses