https://community.qlik.com/t5/App-Development/Conditional-formatting-with-a-number-of-conditions/m-p/1687767#M52420 <P>The below formula doesnot work</P><P>=if(Num(Avg(Age) &gt;= 10, Green(),Red())</P><P>also I need to add And/Or statement to this :</P><P>if brand is 'A' or 'B' and Avg (age)&gt;10 then green else blue</P><P>and if the brand is other than 'A' or 'B' and avg(age) &gt; 80 , then green else blue</P><P>This is very complex. Can someone help me with conditional formatting</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 23 Dec 2021 18:23:25 GMT Mamta123 2021-12-23T18:23:25Z https://community.qlik.com/t5/App-Development/Conditional-formatting-with-a-number-of-conditions/m-p/1687767#M52420 <P>The below formula doesnot work</P><P>=if(Num(Avg(Age) &gt;= 10, Green(),Red())</P><P>also I need to add And/Or statement to this :</P><P>if brand is 'A' or 'B' and Avg (age)&gt;10 then green else blue</P><P>and if the brand is other than 'A' or 'B' and avg(age) &gt; 80 , then green else blue</P><P>This is very complex. Can someone help me with conditional formatting</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 23 Dec 2021 18:23:25 GMT https://community.qlik.com/t5/App-Development/Conditional-formatting-with-a-number-of-conditions/m-p/1687767#M52420 Mamta123 2021-12-23T18:23:25Z