Google Sheets Conditional Formatting with Multiple Variables

Question

Google spreadsheet conditional formatting: I want cell A1 to turn green if it is less than all of B1, C1 and D1.

I can get it to work if it is less than one of the other cells. How do I get it to work, where the condition is "if it is less than all of the other cells"?

pnuts · Accepted Answer · 2017-12-20 22:08:21Z

2

Please try clearing formatting from and selecting ColumnA and Format, Conditional formatting..., Format cells if... Custom formula is and:

=A1<min(B1:D1)

Then select formatting of choice and Done.

answered Dec 20, 2017 at 22:08

pnuts

59.8k11 gold badges93 silver badges141 bronze badges

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

Collectives™ on Stack Overflow

Google Sheets Conditional Formatting with Multiple Variables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related