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...
Bookmarks