View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default number with an automatic color

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