Using the Icon Set for Conditional Formatting

G

Gino59

Hi!

I have a column of currency values that I'm trying to conditionally format
with the arrow icon set (red, green, yellow). What I'm trying to do is
format the currency value with one of the arrows based on its relation to the
previous cell in the column.

c4 shows $234.22
c5 shows $319.87
c6 shows $111.33
c7 shows $113.24

I would like each cell to show the appropriately colored arrow based on the
previous cell's value. If the cell value is higher than the previous cell
value show a red arrow and if it's less show a green arrow and if equal -
yellow.

A bit stumped and I hope this isn't too stupid a question!!

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Query 1
Conditional Formatting (Icon sets - 3 Arrows) 2
Conditional format a column based on value in a different column 3
Conditional Formatting 1
Conditional Formatting for multiple cells 2
Conditional formatting multiple cells from one cell to another 3
Conditional formatting. 1
Icon Sets - Display icon in one cell depending upon value in anoth 2

Top