View Single Post
  #1   Report Post  
Dorn
 
Posts: n/a
Default change the colour of text in cell for minus figure

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