Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Mamta123
Contributor II
Contributor II

Conditional formatting with a number of conditions

The below formula doesnot work

=if(Num(Avg(Age) >= 10, Green(),Red())

also I need to add And/Or statement to this :

if brand is 'A' or 'B' and Avg (age)>10 then green else blue

and if the brand is other than 'A' or 'B' and avg(age) > 80 , then green else blue

This is very complex. Can someone help me with conditional formatting

 

 

0 Replies