Conditional Formatting - attach to data, not cell

[KEI]

Situation: Let's say you have a list in Excel. Within that list, there
is a column to which you have applied conditional formatting. However,
for some reason, you have applied 2 different types of conditional
formatting in the same column.

Perhaps the list contains 2 different classes of employees, and you
want to distinguish achievements with conditional formatting that not
only sets standards higher for one group, but makes the formatting
different as well.

At some point, you might want to sort that list to see who is doing
well. However, when you sort, the formatting remains with the cell,
not the data after the sort.

Is there any way to attach that formatting to the content rather than
the cell?

Thanks for reading this!

-Chris

 

[Dave Peterson]

This might not be worth the effort, but maybe you could use a helper cell in the
same row. Put some kind of indicator of which conditional formula that other
cell has (you said you were only using two).

Then sort the data and use a macro to reapply the conditional formatting.

----
And something else that may not work:

Select your range and do data|filter|autofilter.

Sometimes just filtering on a chosen value is enough--instead of sorting.