| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| cell color shading | Excel Discussion (Misc queries) | |||
| How to change an entire row using conditional formating | Excel Discussion (Misc queries) | |||
| conditional formatting blank cell | Excel Discussion (Misc queries) | |||
Linear Mode
