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.

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.

Hi,

Format | Conditinal format | slelct less than and format as you need

hth
regards from Brazil

"toot033" escreveu:

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.