How to make Cells automatically become 'highlighted' when number .

[Kate]

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.

 

[VT]

In Format > Conditional Formatting

 

[VWP]

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