Use Conditional Formatting.

Format-Conditional Formatting...
Cell Value Is
less than
Enter the less than value

Then set the desired Format options.

"toot033" wrote in message
...
Is it possible to set a condition that will change the color of a value if
it
drops below a certain number. I am trying to to set up cells in an
invnetory
spreadsheet that will change to red when the inventory drops below
certain
reading.
As usual thanks in advance for any and all help.