Progress Bar with conditional formatting

[ebjacob1978]

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

 

[vletm]

ebjacob1978
Without sample file that would be a challenge ... try to send one.

 

[S. Das]

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