If sum>= 60, color cells red

April 2017

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


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.


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!


Solved by rizvisa1


Published by aakai1056. Latest update on September 21, 2010 at 02:48 AM by aakai1056.
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).