Your best bet is conditional formatting. It should stay with the cell even
after a sort.

Post the conditional formatting you are using, and how you are doing the
sort, and what you want to happen differently. Someone will be able to show
you a solution.

Regards,
Fred

"Joebeone" wrote in message
...
I am trying to change a cell color to either red, yellow or green if the
data
in the cell is greater than lets say 90 it would turn red. Less than 90
but
greater than 80 yellow and less than 80 turn to red. Without using
conditional formatting.
Unless there is a way to conditional format the cell and have the
conditional formatting move with the sorting of high to low.
I can do the conditional formatting just fine but when I sort the
conditional formatting stays with the cell it doesn't move with the
sorting.