I've read a lot and I can't seem to find a solution that works for me.
My conditional formatting reads from another table. It colors correctly. But if I try to Custom Sort by color, it looses the color.
My table reads for "Animal","Date","Gender". The colors is set to color red if a there is a "Cat" and "Female". I have the conditional format to read the other table with =AND(cell="cat",other_cell="female"), which works.
So when I try to custom sort for a color, it moved the row to the top, but the color stays in the row it was previously in.
I tried adding a hidden column with "Cat" in one cell and "Female" below it. The cells moved to the top again, but lost all color overall.
My conditional formatting reads from another table. It colors correctly. But if I try to Custom Sort by color, it looses the color.
My table reads for "Animal","Date","Gender". The colors is set to color red if a there is a "Cat" and "Female". I have the conditional format to read the other table with =AND(cell="cat",other_cell="female"), which works.
So when I try to custom sort for a color, it moved the row to the top, but the color stays in the row it was previously in.
I tried adding a hidden column with "Cat" in one cell and "Female" below it. The cells moved to the top again, but lost all color overall.