View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MESTRELLA29 MESTRELLA29 is offline
external usenet poster
 
Posts: 26
Default Conditional Formating Problem

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.