A blank cell would result in a value less than 15%, which might be why the
empty ones are highlighted. In your formula, do you have to have the IF
statement return a blank cell? Can you have it return a character other than
a number?

"GatorGirl" wrote:

I am using office 2007 and have a formula in column F which states IF(E4=" ",
" ", E4/A4). This keeps the column formatted throughout the worksheet. I
now need to identify using conditional formatting, any cell which is greater
than 15% and less than 15%. When I choose this option through conditional
formatting, the empty cells are highlighted.

Any suggestions?

Thank you