+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting - Sliding bar comparing two columns

  1. #1
    Registered User
    Join Date
    10-27-2011
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    8

    Conditional Formatting - Sliding bar comparing two columns

    Hi everyone,
    I have two columns containing numbers, lets call them Column A and Column B.

    I would like a sliding bar similar to the Conditional Formatting Data Bar to be shown in column A to illustrate how much larger or smaller that number is compared to the one in Column B.

    For example:
    If A and B were the same, the bar in column A would be in the middle.
    If A was less than B, the bar would slide to the left
    If A was greater than B, the bar would slide to the right and so on.

    This would be as a percentage I suppose of A?

    Any help greatly appreciated...

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    14,761

    Re: Conditional Formatting - Sliding bar comparing two columns

    I don't think you can put that in column A. CF icons and bars only work on the cell to which the CF is applied. You could put a formula in column C to give the difference or difference as a percentage of A, and use CF on that.
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1