PDA

View Full Version : Conditional Formatting trending with Icon Set



RGottesman
2015-03-04, 04:35 PM
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

sambit
2015-04-30, 12:08 PM
Hi,
plz see the file. I think it may help.

RGottesman
2015-04-30, 06:58 PM
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)3448