0
Thanks

A few words of thanks would be greatly appreciated.

If sum>= 60, color cells red

==If sum>= 60, color cells red==

Issue

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.

Solution

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!

Note

Solved by rizvisa1

0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « If sum>= 60, color cells red », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).