number with an automatic color

[Guest]

Good day to everyone, I'm not sure if there is a pssible answer of my
question. We keep a worksheets and we input a diffrent figures or number, We
had a certain range of number it required to meet the tolerable gain or loss
in our operations.
What we need is if we input a number which is out of tolerance the color
could be automatically change to blue or etc.
I tried format - conditional formating but only the cell color was change .
What we is the number or figure could be chnage and not the cell..

Example:

Our range is 10 up to 15

if we input #9 or #16 the color of the number could be change to blue or
else.

Thank
Mike

 

[Guest]

Hi Mike:

You are almost there.

Once you have set the condition, select the Font tab and pick the color. If
you select the Pattern Tab, the color will be applied to the cell background
and not the value.

 

[Guest]

Gary,
Thank you so much, you're my hero.

Hi Mike:

You are almost there.

Once you have set the condition, select the Font tab and pick the color. If
you select the Pattern Tab, the color will be applied to the cell background
and not the value.