Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to make Cells automatically become 'highlighted' when number .
I'd like to make specific Cells in a spreadsheet become automatically
'highlighted' when the specific number in that cell goes below a pre-determined figure ie when the nubmer goes from 100 to 63 which is below the pre-determined '75' the cell would become yellow or red. |
#2
|
|||
|
|||
In Format Conditional Formatting
"Kate" wrote in message ... I'd like to make specific Cells in a spreadsheet become automatically 'highlighted' when the specific number in that cell goes below a pre-determined figure ie when the nubmer goes from 100 to 63 which is below the pre-determined '75' the cell would become yellow or red. |
#3
|
|||
|
|||
First you must select the specfic cells you want "highlighted" by holding
down the "Ctrl" key and clicking on the cells. Then on the menu bar select Format/Conditional Formatting and select "Cell Value Is" select "between" and type your criteria in the empty boxes. Then press the "Format..." button choose "Patterns" and select your color. Press the "OK" button to take you back and press the "Add " button to create other criteria for the same cells you selected and repeat the process. Hope it helps VWP "Kate" wrote: I'd like to make specific Cells in a spreadsheet become automatically 'highlighted' when the specific number in that cell goes below a pre-determined figure ie when the nubmer goes from 100 to 63 which is below the pre-determined '75' the cell would become yellow or red. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Count number of shaded cells | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
How to make Cells automatically become 'highlighted' when number . | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |