If sum>= 60, color cells red

Question

If sum>= 60, color cells red

[Solved/Closed]

Report

mindy - Sep 20, 2010 at 04:44 PM
mindy - Sep 20, 2010 at 06:18 PM

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.

Excel if cell color is red then sum
Excel sum cells by color conditional formatting - Best answers
Sum colored cells in excel without vba - Best answers
Excel if cell color is red then - How-To - Excel
Excel if text color is red then ✓ - Forum - Excel
How to change value based on cell color in excel ✓ - Forum - Office Software
Excel vba - change cell color based on value ✓ - Forum - Programming
Excel if cell contains specific text then change color ✓ - Forum - Excel

2 replies

Ask a question

rizvisa1 · Answer 1 · 2010-09-20T16:48:09-0400

Answer 1 / 2

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

768
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. ?

mindy · Answer 2 · 2010-09-20T16:55:36-0400

Answer 2 / 2

mindy
Sep 20, 2010 at 04:55 PM

if the Sum of C23, C24, C25 >= 60, I'd like all three cells to be red

Report

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

768
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!

If sum>= 60, color cells red

2 replies

Your reply

Sur les mêmes thèmes

Subscribe To Our Newsletter!