Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel conditional formating decimal fractions | Excel Worksheet Functions | |||
can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) | |||
IF Command conditional formating | Excel Worksheet Functions | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
30 Day Aging Report Using Conditional Formating | Excel Worksheet Functions |