Conditional change to cell color
 

I would like to make the color of a cell become "yellow" by formula or
automatically, when the number in the cell exceeds a certain quantity. Any
help?

Richard wrote:
I would like to make the color of a cell become "yellow" by formula or
automatically, when the number in the cell exceeds a certain
quantity. Any help?

Format-Conditional Formatting. "Cell value is greater than", 2, format to
yellow

Format | Conditional Formatting will do this for you. Select the cells in
which you want this to happen. Then, just choose the value you want, the
constraint you want, and set the format you want.

tj

"Richard" wrote:

I would like to make the color of a cell become "yellow" by formula or
automatically, when the number in the cell exceeds a certain quantity. Any
help?

Thank you. It works great!

"tjtjjtjt" wrote:

Format | Conditional Formatting will do this for you. Select the cells in
which you want this to happen. Then, just choose the value you want, the
constraint you want, and set the format you want.

tj

"Richard" wrote:

I would like to make the color of a cell become "yellow" by formula or
automatically, when the number in the cell exceeds a certain quantity. Any
help?