Hello, I have a budgeting sheet where I'd like to show a vertical line against some progress bars at a value other than zero. In particular, I'd like to highlight where budgets are at more than 100%. It looks like conditional formatting can only handle that if the value you're targeting is zero.
I'm currently just drawing a vertical line at the 100% mark, but would like to do it dynamically if possible (I've forgotten to update it occasionally). Any ideas on how to accomplish this?
Delta: vertical line at 0 using conditional formatting
Percent: vertical line at 100 using vertical line
I'm currently just drawing a vertical line at the 100% mark, but would like to do it dynamically if possible (I've forgotten to update it occasionally). Any ideas on how to accomplish this?
![a0msp2t.png](/board/proxy.php?image=https%3A%2F%2Fi.imgur.com%2Fa0msp2t.png&hash=24cb1344fd2fb7e01ebf8e35dcb95f54)
Delta: vertical line at 0 using conditional formatting
Percent: vertical line at 100 using vertical line