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