0

I am trying to highlight all the values in B2:D4 that are greater than the value in B7. Tried with =or(B2>B7,C2>B7, D2>B7) and others, but I could not get what I wanted.

Data for conditional formatting

1 Answer 1

1

Try the following: =(B2>$B$7) as formula.

You need to use the most upper-left cell as a dynamic reference. Sheets then automatically does the dynamic mapping to all the other cells the conditional formatting should be applied to.

1
  • Thanks for the tip: using the most upper-left cell as a dynamic reference.
    – sofname
    Commented May 31, 2021 at 21:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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