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.