View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nelson B. Nelson B. is offline
external usenet poster
 
Posts: 35
Default Automatically changing arrows

I have a report for executives where I have a big "up" arrow if there was an
increase and a big "down" arrow if the amount decreased. Currently I have to
change these by hand each month. How do you automate the arrow to change
based on whether a referenced cell is pos. or neg.?

Thanks!