Shade a cell when it is within a percent range

[Nvablejrg]

Goodday everyone,

I am trying to figure out how to get a cell to shade when my metric is in between a percentage range. I need it to be green within the tolerance and red outside.

I cannot seem to find a way to do it and I seem to not know the proper verbage to search.

A sample is below.

G > 95%-91% < R

Thank everyone in advance.

Nvablejrg

 

[Roderick_E]

I'm supposing you are using Conditional Formatting
you need to use 2 rules. 1 for the green and one for the red.

 

[Nvablejrg]

Thank you for your response.

I thought I would have to do the way you suggested but it is not working for me.

I will continue to wrestle with it using trial and error. It is probably staring me right in the face.