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.

Hi,

That process is very simple. Microsoft Office 2007 has made it even easier.
In the "Home" Tab in the "styles" section select conditional formatting, then
you can click on "Highlight Cell Rules" and then on "greater than" or "lower
than" depending on your rule.
After selecting that another window should pop up asking for the value you
want to use as the criteria and then you can select from the drop down box
which format would you like to choose(Make sure to select " custom format").

Hope that helps,

Vicente.
--
Vicente Tulliano


"Joebeone" wrote:

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.