You can use conditional formatting for this.On 2002-07-05 10:45, bdanner wrote:
I am trying to find out how you would color code a cell. I'd like to have it set so if the results of the formula in that cell are greater than 97, the cell is colored green. If the results are less than 97 it would be red. Is there an Excel formnula that would allow for this?
Highlight the cells you want this to happen for.
Choose conditional formatting from the format menu.
For condition one, select greater than from the drop down box, and type in 97.
Click on the forat box and choose a green color.
Click on the add button, and repeat the process for your less than 97 criteria.