Comparing Cells with Arrow Output

  • Thread starter Thread starter charper
  • Start date Start date
C

charper

We have a spreadsheet that we want to compare the values in one cell t
the value in another cell to determine if there was in increase o
decrease in the numbers.

The third column is to be a column that will have either an "up" arro
or a "down" arrow depending on the solution however how would you g
about formatting so that the arrow is either up or down depending o
the outcome, or is this even possible?

Thanks for your help
 
Hi

You could use an IF function:
=IF(A2>B2,"h",IF(A2<B2,"i",""))

and format the result as Wingdings3
 
I've tried both of those solutions and on both solutions get an arro
pointing to the left.

Any other suggestions?
We are using Excel 2000. Would the version matter
 
Ok, I realized I was using the wrong line numbers for the formula.
Sorry about that.

Next question.

Can you apply different colors to the results?

So that the up arrow is green and the down arrow is red
 
Hi
you may use conditional formating for this. Within the conditional
formating dialog use smething like
=CODE(A1)=173
and choose a format for this condition
 
Back
Top