i'm trying to add a function that will automatically change the colour of the
figures in cells when they become either a low number or a minus figure to
help me with a stock count sheet. ie. 20 items on hand sold 15 remaining 5,
would like the 5 to hange to red as a visual warning of low stock. i,m using
office pro on xp. Thank you

have a look at CONDITIONAL FORMAT
formatconditional formattingpretty easy

--
Don Guillett
SalesAid Software

"Dorn" wrote in message
...
i'm trying to add a function that will automatically change the colour of
the
figures in cells when they become either a low number or a minus figure to
help me with a stock count sheet. ie. 20 items on hand sold 15 remaining
5,
would like the 5 to hange to red as a visual warning of low stock. i,m
using
office pro on xp. Thank you

Thanks Don that did the trick

"Don Guillett" wrote:

have a look at CONDITIONAL FORMAT
formatconditional formattingpretty easy

--
Don Guillett
SalesAid Software

"Dorn" wrote in message
...
i'm trying to add a function that will automatically change the colour of
the
figures in cells when they become either a low number or a minus figure to
help me with a stock count sheet. ie. 20 items on hand sold 15 remaining
5,
would like the 5 to hange to red as a visual warning of low stock. i,m
using
office pro on xp. Thank you

glad to help

--
Don Guillett
SalesAid Software

"Dorn" wrote in message
...
Thanks Don that did the trick

"Don Guillett" wrote:

have a look at CONDITIONAL FORMAT
formatconditional formattingpretty easy

--
Don Guillett
SalesAid Software

"Dorn" wrote in message
...
i'm trying to add a function that will automatically change the colour
of
the
figures in cells when they become either a low number or a minus
figure to
help me with a stock count sheet. ie. 20 items on hand sold 15
remaining
5,
would like the 5 to hange to red as a visual warning of low stock. i,m
using
office pro on xp. Thank you