If sum>= 60, color cells red
Solved/Closed
Related:
- Excel if cell color is red then sum
- Sum colored cells in excel without vba - Best answers
- Excel sum cells by color conditional formatting - Best answers
- Excel if cell color is red then - Guide
- Excel change cell color based on dropdown selection ✓ - Forum - Excel
- Excel change cell color based on value of another cell ✓ - Forum - Excel
- Excel if cell color is green then - Forum - Excel
- Excel vba - change cell color based on value ✓ - Forum - Programming
2 replies
rizvisa1
Sep 20, 2010 at 04:48 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Sep 20, 2010 at 04:48 PM
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. ?
if the Sum of C23, C24, C25 >= 60, I'd like all three cells to be red
rizvisa1
Sep 20, 2010 at 06:03 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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
=(C$23 + c$24 + c$25)>=60 and choose color red, I think it would work
