If sum>= 60, color cells red

Solved/Closed

Excel

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.

Sum cells by color
Excel if cell color is red then sum - Best answers
Sum cells by colour - Best answers
Rj45 color - Guide
Notepad++ change background color - Guide
Powertoys color picker - Download - Other
Based on the values in cells b77 b81 ✓ - Excel Forum
Sum if greater than and less than cell value ✓ - Excel Forum

2 responses

Answer 1 / 2

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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. ?

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

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

mindy
Sep 20, 2010 at 06:18 PM

Yay, thanks!

Similar discussions

How to use conditional format based on text?

Condition formatting on changing cell color based on another cel

Change colour of range of cells based upon text from a drop down menu in another

Conditional formatting: change fontcolor based on another cell

Pop up message stating empty cells

Excel: Merge adjacent rows if they contain the same values

Similar discussions

Subscribe To Our Newsletter!