Conditional Formatting problem

[dkidroske]

I have a worksheet that I had conditionally formatted to display different colors for values between 0.000001% and 100%. The last formatting selection was for >.5.

As this data aged I began to have some Div/0 errors so I put an if statement in front of the formula and made it a null entry (IF(b2>0,A2/B2,"").

That worked just fine for getting rid of the Div/0 errors but now the cells with null entry are formatting green like the cells with >.5.

I've tried several things but haven't figured it out.

Any ideas?

 

[Joe4]

Let's say that you are placing this Conditional Formatting in cell C2.
Then use the "Formula Is" option and use this formula:

=and(isnumber(c2),c2>0.5)

 

[dkidroske]

Let's say that you are placing this Conditional Formatting in cell C2.
Then use the "Formula Is" option and use this formula:

=and(isnumber(c2),c2>0.5)

Many thanks, Joe!!