Yes, It is Possible,  If you are using Excel 2000:

Highlight cells that meet specific conditions
Select the cells you want to highlight.

On the Format menu, click Conditional Formatting.

Do one of the following:
To use values in the selected cells as the formatting criteria, click
Cell Value Is, select the comparison phrase, and then type a value in
the appropriate box. You can enter a constant value or a formula. If you
enter a formula, you must start it with an equal sign (=).

To use a formula as the formatting criteria (to evaluate data or a
condition other than the values in selected cells), click Formula Is in
the box on the left, and then enter the formula in the box on the right.
The formula must evaluate to a logical value of TRUE or FALSE.

Click Format.

Select the font style, font color, underlining, borders, shading, or
patterns you want to apply.
Microsoft Excel applies the selected formats only if the cell value
meets the condition or if the formula returns a value of TRUE.

To add another condition, click Add, and then repeat steps 3 through 5.
You can specify up to three conditions. If none of the specified
conditions are true, the cells keep their existing formats. You can use
the existing formats to identify a fourth condition.

the above taken from help.

It should work for you.



Robert Lendrim wrote:

> I am making a personal Excel spreadsheet to record numerical medical test
> results. The purpose is to monitor improving numbers as time passes. The
> results are more graphic and easier to interpret if the entries are color
> coded. I have been doing that manually. Is it possible to have Excel
> automatically color a cell entry green, yellow, or red depending on it's
> numeric value?
> Thank you. Bob Lendrim

      "Hold No Punches.." Rode brings you great shareware/freeware
        programs with his honest opinions in this weekly column.
                       http://freepctech.com/rode