0

If a Google Sheet cell has 2 Conditional formattings, one which changes only font color, one which changes only the background, only the first conditional formatting affects the cell.

The reason might be because when the color is set to NONE, it is not interpreted as transparent.

When I set a font or background color to NONE, it should be transparent, so other conditions could affect the transparent part.

Demo sheet attached: https://docs.google.com/spreadsheets/d/1AFX8PBlKEJszK3MotTompP9OufD4OrMUrOz8E-mC5jk/edit?usp=sharing

An idea on how to fix it?

0

First of all, you will never get a blue background with =C4>1. you have to change it to =C4>0 or =C4=1

Conditional formatting rules are priority based and if one rule is applied the other rules just skip it. To resolve it you will need to add one more rule with: =AND(C4>0;B4>0)

0

  • Almost good. True, but can not change the order of the format rules. So I need other solution to avoid deleting old rules (rule change still allowed). – klor Mar 6 at 17:38
  • you can just clone them down by one and then edit the first one and delete rest of the clones – user0 Mar 6 at 17:40
  • 1
    I found a drag&drop panel to change the order at least in webbrowser. But how to clone them? – klor Mar 6 at 17:44
  • yup, drag&drop is also an option... – user0 Mar 6 at 17:47
  • 1
    cloning is basically done by clicking on CF rule to edit it but instead of any edit you click on +Add another rule and then click on Done – user0 Mar 6 at 18:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.