Results 1 to 3 of 3

Thread: Conditional Formatting trending with Icon Set

  1. #1

    Conditional Formatting trending with Icon Set



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    plz see the file. I think it may help.
    Attached Files Attached Files

  3. #3
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •