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.
|