Felix Ronneberger
Felix Ronneberger

Reputation: 23

Google sheets conditional formatting depending on other cell

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!

Upvotes: 1

Views: 106

Answers (1)

pnuts
pnuts

Reputation: 59460

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

=A2<$A$24

Upvotes: 1

Related Questions