Forum Discussion

Copper Contributor

May 15, 2017

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 c...

Diamond Contributor

May 15, 2017

Hi Daan,

For conditional formatting use the rule

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

and apply it to

$B$3:$B$10

daan krabbendam
Copper Contributor
May 15, 2017
Hi Sergei,

Thanks for your reply.
Upon entering the formula below I receive the following error:
=($C3<=0.8*$C$11)
- Yury Tokarev
  Iron Contributor
  May 15, 2017
  You can also omit brackets in this instance: =$C3<=$C$11*0.8
  - SergeiBaklan
    Diamond Contributor
    May 16, 2017
    That's more about "coding standard"...
- daan krabbendam
  Copper Contributor
  May 15, 2017
  Got it :) , instead of .
  
  Thanks a lot for your help!