Conditional Formation with formula - Excel 2010

[SVTF]

Hello Excel Guru's

Please see the attached test workbook.

I have what I think is the correct conditional formatting on the column C - however not getting the desired results.

End game ... 2 possible outcomes

Have the cell turn yellow if result in cell is less than 100%
Have the cell turn red if result in cell is less than 80%

I selected the whole set of data C7:C17 and added to conditional format formulas
C7<C4 - Yellow
C7<C5 - Red

But it is not working as needed ... Where am I going wrong?

Need to do this in 4 columns all having the same 100% / 80% meet thresholds.

Thanks in advance

[6StringJazzer]

To always compare to C4 and C5 for all cells use this

C7<$C$4 - Yellow
C7<$C$5 - Red

The reference percentages in C4 and C5 must be absolute references, not relative references. If your rule says

C7<C4

it will compare every cell to the one three rows higher, not to C4.

[SVTF]

Thank You .. knew I was missing something.