If sum>= 60, color cells red

December 2016


==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

Related :

This document entitled « If sum>= 60, color cells red » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.