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!)?