Hi,
plz see the file. I think it may help.
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.
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)conditional formatting.xlsx
Bookmarks