conditional formatting based of percent of another cell?

[empeters27]

I am trying to set up formatting based on the percent of another cell. I've attached a screenshot to provide context.

I have manually color coded these but I would like it to be automatic as follows: based horizontally (rows)

If a cell is 100% or more of the goal, it should be green.

If a cell is 85%-99% of the goal it should be yellow.

If a cell is 84% or lower than the goal it should be red.

Can someone help me figure out how to do this?  

[#2]

@empeters27 

Select C2:H100 or however far down thew data go. C2 should be the active cell in the selection.

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Format on;y cells that contain'.

Leave the first drop-down set to 'Cell Value'.

Select 'not equal to' from the second drop down.

Enter ="" in the box next to it.

Click Format...

Activate the Fill tab.

Select red.

Click OK, then click OK again.

Repeat these steps, but with 'greater than or equal to', with the formula =85%*$B2 and yellow.

Finally repeat them again, but with 'greater than or equal to', with the formula =100%*$B2 and green.

[#3]

@empeters27 

You may want to add one more rule, with 'equal to', ="NA" and No Color.