I'm trying to apply conditional formatting on column g where the formula in
each cell is =IF(c5,g5/c5,"") or as appropriate for that row and it returns a
percent value. I want those values greater than $G$4 to be highlighted in
red. The value in G4 is 10%.

Two problems.
1) My highlighting returns all my blank cells in column G in red
2) If I try to format the 'cell value $G$4" and the value is greater than
10%, the highlighting doesn't show. If I use the formatting of 'cell value
..1' then it works. I want to be able to change the value in G4 so I need it
to work the first way.

I hope this makes sense.