Google-sheets – column conditional formatting based on its sum

conditional formattinggoogle sheets

I have column F2:F23. I want the background of that entire column (F2:F23) to either turn red or stay neutral based on whether the sum of the column is greater than the number at cell C2. I tried conditional formatting but it's not working.

=Sum(F2:F23)>C2

Best Answer

The Conditional formatting rule should be Greater than =$C$2

Like this:

Related Solutions

Google-sheets – Is it possible to add conditional formatting when number changes

This is not possible as far as I can tell. Google's conditional formatting is not very robust.

Here is Google's Conditional formatting help, although I don't think it's very helpful in your situation. It doesn't appear you can even use a cell value for the conditional formatting.

EDIT:

I found this link recently. It's much more complicated, but you can do what you want using their Javascript API.

Google Sheets Conditional Formatting – Format Range Based on Other Cell Values

As for other formulae, conditional formatting rules are required to start with =. So for green I adjusted to:

=$G2 <= $B2

and for red to:

=$G2 > $B2

Range for both of G2:G5 is fine if you just want the highlighting to apply to ColumnG but if to apply to ColumnsC:G then change Range: to C2:G5.

Best Answer

Related Solutions

Google-sheets – Is it possible to add conditional formatting when number changes

Google Sheets Conditional Formatting – Format Range Based on Other Cell Values

Related Topic