View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
b_dhan b_dhan is offline
external usenet poster
 
Posts: 1
Default Using If Statements to change colours

hi everyone I was wondering if someone could help me out with a simple excel
sheet that i have programmed to keep my stocks upto date. The problem I have
is that I have data that refreshes continuiously and its numbers so i want to
be able to detect if its a loss or gain right away. I was wondering if there
is some sort of If Statement to help me change colour of background colour
for the cell or the text in the cell which automatically refreshes positve or
negative numbers.
Hope somebody understands what I'm saying and hopefully there is a easy to
moderate way of doing becuase im not a professional with this program.
THANKS and hope to hear from you soon.