Previous Topic Next Topic

If sum>= 60, color cells red

Solved/Closed
mindy - 20 Sep 2010 à 16:44
 mindy - 20 Sep 2010 à 18:18
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 responses

Réponse 1 / 2
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
20 Sep 2010 à 16:48
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. ?

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response
Change colour of range of cells based upon text from a drop down menu in another
Jim1409 -
TrowaD -

1 response
Conditional formatting: change fontcolor based on another cell
wandanuila -
Ravi -

18 responses
Pop up message stating empty cells
benji -
shalom1506 -

7 responses
Excel: Merge adjacent rows if they contain the same values
kobe1121 -
lukal4 -

16 responses