View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default How can I show up and down arrows when a value changes?

Hi,
Highlight the column, do conditional formating, icon sets, choose the arrows

"Julie" wrote:

I'm creating a financial spreadsheet on comparison of year-to-year and
month-to-month sales. If the sales go up from previous year, I want to show
an up arrow beside it and if it goes down, down arrow. How can I achieve
this? Can I make it an automatic thing for instance if the number is postive,
it's an up arrow and negative down arrow?