conditional formatting in a table over 100%

[AndrewPF]

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?  

[serpiva64 · Accepted solution]

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 !