Previous Topic Next Topic

If sum>= 60, color cells red

Solved/Closed
Report
-
 mindy -
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.

Related:

2 replies

Answer 1 / 2
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
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. ?
Answer 2 / 2

if the Sum of C23, C24, C25 >= 60, I'd like all three cells to be red
Report
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
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

Yay, thanks!
Ask a question