How to format based on one column for each row?

[morgancampbell]

I have data as below:

Name	Percentage
Name 1	90%
Name 2	70%

And I'm looking to set up conditional formatting so that anything above a certain percentage, the entire column is filled red. Likewise, anything with a certain range I want to fill yellow.

I can figure out how to set a rule for one cell, but am unsure of how to autofill this for the entire table. 

How would I go about this?

Thanks,

Morgan

[#2 · Accepted solution]

@morgancampbell 

That could be such rule

applied to your entire range. Be sure about absolute and relative references in formula.