Condition 2

=AND($N$5/$D$50%,$N$5/$D$5<100%)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MESTRELLA29" wrote in message
...
I have the folowing condition formating
condition 1 =$N$5/$D$5=100% Aply green pattern
condition 2 =$N$5/$D$5<1%100% Aply yellowpattern
condition 3 =$N$5/$D$5=0% Aply whitepattern

The first 2 conditions work well, wen the formula results in 0 the
patterns
that is return is yellow, what am i doing wrong.