1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Progress Bar with conditional formatting

Discussion in 'Ask an Excel Question' started by ebjacob1978, Jan 10, 2018.

  1. ebjacob1978

    ebjacob1978 New Member

    Messages:
    3
    Hello There
    I am Jacob and New to this site

    I have a requirement with conditional formatting to show the progress bar in a cell.
    Column A has all the target data and Column B has all the incoming data.
    When anyone types the data(number) in B, it should compare the percentage against target from A and show the bar. I tried in excel with single cells and it works, but when I select all the rows (nearly 500 cells) it says circular reference is not allowed.

    Can anyone guide me?

    Thanks
    Jacob
  2. vletm

    vletm Excel Ninja

    Messages:
    3,667
    ebjacob1978
    Without sample file that would be a challenge ... try to send one.
  3. S. Das

    S. Das Member

    Messages:
    88
    I think you need something like this...
    See the attachment and tell me if this is helpful

    Attached Files:

    Syndp likes this.

Share This Page