Forum Discussion
Conditional formatting formula
Dear community,
I'm struggling with setting up a formula within conditional formatting. I tried setting up a new rule but to no avail.
The task is to set up a rule that highlights the data in column b3;b10 whenever the quantity is 20% lower than the calculated average, 11.75 in this case.
| Fruit/Vegetables | Quantity | ||
| Banana | 20 | ||
| Tomato | 12 | ||
| Pear | 6 | ||
| Apple | 7 | ||
| Cucumber | 19 | ||
| Cherry | 17 | ||
| Avocado | 9 | ||
| Carrot | 4 | ||
| Average | 11,75 | ||
Your help is much appreciated.
5 Replies
Hi Daan,
For conditional formatting use the rule
=($C3<=0.8*$C$11)
and apply it to
$B$3:$B$10
Hi Sergei,
Thanks for your reply.
Upon entering the formula below I receive the following error:=($C3<=0.8*$C$11)
You can also omit brackets in this instance: =$C3<=$C$11*0.8
