Menu
Ask a question Report

If sum>= 60, color cells red [Solved/Closed]

- Sep 20, 2010 at 04:44 PM - Latest reply:  mindy
- Sep 20, 2010 at 06:18 PM
Excel Ask a question Report
Hello,

I have excel 2007 and am trying to set conditional formatting for a series of 3 cells. If their total sum is greater than or equal to 60 I want the cells to be filled in red.

See more 

4 replies

Report Respond to rizvisa1
Posts
4481
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
 - Sep 20, 2010 at 04:48 PM
0
Thank you
What is exactly meant by "series of cells" ? If by that you mean to say that on each row, you have 3 cells and you want to add the sum the three cells on that row and if the sum comes out to be 60 you want to color the cells red. ?
Report Respond to mindy
- Sep 20, 2010 at 04:55 PM
0
Thank you
if the Sum of C23, C24, C25 >= 60, I'd like all three cells to be red
Report
Posts
4481
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
 - Sep 20, 2010 at 06:03 PM
If you click on cell C23 and select till cell 25 and then go to conditional format and enter formula
=(C$23 + c$24 + c$25)>=60 and choose color red, I think it would work
Report
mindy - Sep 20, 2010 at 06:18 PM
Yay, thanks!
Ask a question