change the colour of text in cell for minus figure

[Guest]

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

 

[Don Guillett]

have a look at CONDITIONAL FORMAT
format>conditional formatting>pretty easy

 

[Guest]

Thanks Don that did the trick

have a look at CONDITIONAL FORMAT
format>conditional formatting>pretty easy

 

[Don Guillett]

glad to help