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.


2 Answers 2


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

Like this:
enter image description here

  • That didn't work
    – Mwen Rele
    Mar 17, 2020 at 15:16
  • @MwenRele, please share a sample sheet with what you tried and I'll take a look at it Mar 17, 2020 at 17:08
  • all you have to do is open a Sheet. in cell C2 write the number 200 and then choose another column to test the conditional formula against. That's all you need to test this.
    – Mwen Rele
    Mar 17, 2020 at 21:32
  • I did that and it workee, therefore I was asking for a sample from you to see what you were missing Mar 17, 2020 at 22:05
  • @MwenRele see here a short screen recording videobin.org/+177k/1d9x.html Mar 17, 2020 at 22:10

I finally figured it out. The answer is this:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.