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

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
    May 31 at 21:13

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.