Conditional change to cell color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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?
Click to expand...

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
 
Thank you. It works great!

tjtjjtjt said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Conditional format color change 2
Change Color of cell 3
Conditional Formating based on Date 5
Changing cell colors 1
Excel Macro to automatically go to the right of the last colored cell 0
Color row based on cell value 1
Formula to set cell color 3

Back
Top