Conditional formatting formula

[daan krabbendam]

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.

[#2]

Hi Daan,

For conditional formatting use the rule

=($C3<=0.8*$C$11)

and apply it to

$B$3:$B$10

[#3]

Hi Sergei, 

Thanks for your reply.
Upon entering the formula below I receive the following error:

=($C3<=0.8*$C$11)

[#4]

Got it :) , instead of .

Thanks a lot for your help!

[#5]

You can also omit brackets in this instance: =$C3<=$C$11*0.8

[#6]

That's more about "coding standard"...