Excel: Conditional Formatting Colors after sorting

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.

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of April 06, 2017.

For more resources for Microsoft Excel