Forum Discussion
AndrewPF
Helper V
Helper Vconditional formatting in a table over 100%
Sorry, I know this has been asked before, but I can't find an exact answer anywhere.
My pseudodata looks like this:
| group | target | actual | target PC |
| RODS | 3 | 4 | 133.3% |
| BOXES | 2 | 2 | 100.0% |
| HOOKS | 9 | 8 | 88.9% |
| BAIT | 11 | 8 | 72.7% |
| LINES | 5 | 6 | 120.0% |
and I want to put it in a table where the "target PC" column is formatted as above i.e. red under 100%, and green 100% or over.
But the conditional formatting won't let me go over 100%.
What am I missing?
Hi,
if you want to obtain this:
you need to conditional formatting this way:
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution !
1 Reply
- serpiva64
Solution Sage
Hi,
if you want to obtain this:
you need to conditional formatting this way:
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution !