OK I get the info about text always being greater than any value now.
I'm sorry I don't understand the reference to the Count A1. How does that
impact my text value?

If I want to apply your formula below to all the cells in column g (g8:g38)
how do I do that? Can I highlight the range and apply once formula or do I
have to do it for each cell in the range?

Thanks for your help

"T. Valko" wrote:

The problem is due to your formulas returning a formula blank ("") which is
a TEXT value.

In Excel, a text value will *always* evaluate to be greater than any number.

"text" 1,000,000,000,000 = TRUE

So: "" $G$4 = TRUE and the formatting is being applied.

Use the Formula Is option and test that the cell(s) do in fact contain a
number:

=AND(COUNT(A1),A1$G$4)

--
Biff
Microsoft Excel MVP


"mgccoop" wrote in message
...
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.