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
    Excel Version
    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