Conditional Formatting trending with Icon Set

RGottesman

New member
Joined
Mar 4, 2015
Messages
5
Reaction score
0
Points
0
I am trying to understand how conditional formatting Icon Sets work. I would like to compare column B to column A, if there is an increase show Green arrow up, if it is the same show arrow side ways, if there is a decrease show arrow down.


How do I do this?

thanks in advance
 
Hi,
plz see the file. I think it may help.
 

Attachments

  • Test.xlsx
    8.3 KB · Views: 35
Thank you so much I found the following work around. Please see the attached file.

In order for this to work the following procedure must be followed:

create a conditional formatting icon set for 1 cell
edit with the indirect formula
copy formatting
paste formatting cell by cell (whole sections will not work)View attachment conditional formatting.xlsx
 
Back
Top