I have a column of data containing Dow Jones Industrial Average for every
day, latest day being in the topmost cell.

I shall like to format it with an up arrow icon, if the DJIA is greater
than previous day, else down arrow icon.

How do I do that?

I'm not sure how you're going to use conditional formatting to add an arrow, but
maybe you could use an additonal cell and use a formula:

Give B3 a Wingdings font and this formula:
=if(a2=a3,"",if(a2<a3,char(241),char(242)))


Ravi Bakshi wrote:

I have a column of data containing Dow Jones Industrial Average for every
day, latest day being in the topmost cell.

I shall like to format it with an up arrow icon, if the DJIA is greater
than previous day, else down arrow icon.

How do I do that?

--

Dave Peterson

Many thanks for the suggestion.

I have a lot of columns in this spreadsheet and I wanted to avoid adding
another column.

I was hoping against hope that Microsoft might have provided an easier way
of adding an up or a down arrow within the same cell for such a common
situation.

I do thank you sincerely for taking the time to read the post and suggest a
solution.

Best regards, [:-D

"Ravi Bakshi" wrote:

I have a column of data containing Dow Jones Industrial Average for every
day, latest day being in the topmost cell.

I shall like to format it with an up arrow icon, if the DJIA is greater
than previous day, else down arrow icon.

How do I do that?