$$Excel-Macros$$ Count the no of Red colored cells and green colored cells

2012-10-30 Thread Sundarvelan N
Dear Gurus, Please help me to Count the no of Red colored cells and green colored cells. Thanks N.Sundarvelan 9600160150 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate

Re: $$Excel-Macros$$ Count the no of Red colored cells and green colored cells

2012-10-30 Thread Aamir Shahzad
hi Sundarvelan, You can use the following array formulas for count the Red Green cells. Please note it's calculating the cell values not cell colors. See the attached file. =COUNT(IF(D2:AG2C2,D2:AG2)) =COUNT(IF(D2:AG2=C2,D2:AG2)) Aamir Shahzad On Tue, Oct 30, 2012 at 4:11 PM, Sundarvelan N

Re: $$Excel-Macros$$ Count the no of Red colored cells and green colored cells

2012-10-30 Thread RAJA SEKAR
file with formula On 30 October 2012 16:41, Sundarvelan N nsund...@gmail.com wrote: Dear Gurus, Please help me to Count the no of Red colored cells and green colored cells. Thanks N.Sundarvelan 9600160150 -- Join official facebook page of this forum @