Google sheets conditional formatting depending on other cell

Question

I'm trying to make every cell in range A2:G21 green if its value is lower than A24. I thought It would be quite easy but I just can't figure it out. Thanks in advance!

pnuts · Accepted Answer · 2018-06-07 16:01:35Z

1

Select from A2 to G21 and apply a Custom formula is of

=A2<$A$24

answered Jun 7, 2018 at 16:01

pnuts

59.7k11 gold badges92 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Google sheets conditional formatting depending on other cell

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related