Conditional Formatting on empty cells
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.
|