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?
Delta: vertical line at 0 using conditional formatting
Percent: vertical line at 100 using vertical line