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.


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

Like this:
enter image description here

  • That didn't work
    – Mwen Rele
    Mar 17 '20 at 15:16
  • @MwenRele, please share a sample sheet with what you tried and I'll take a look at it Mar 17 '20 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 '20 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 '20 at 22:05
  • @MwenRele see here a short screen recording videobin.org/+177k/1d9x.html Mar 17 '20 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, privacy policy and cookie policy

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