0

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
Improve this question

2 Answers 2

Reset to default
0

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

Like this:
enter image description here

Improve this answer
6
  • That didn't work Commented Mar 17, 2020 at 15:16
  • @MwenRele, please share a sample sheet with what you tried and I'll take a look at it Commented 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. Commented 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 Commented Mar 17, 2020 at 22:05
  • @MwenRele see here a short screen recording videobin.org/+177k/1d9x.html Commented Mar 17, 2020 at 22:10
0

I finally figured it out. The answer is this:

=Sum($F$2:$F$23)>$C$2
Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.