 H2OuUp2Happy to be herePremium
join:2002-03-15
Oklahoma City, OK | reply to 2kmaro
Re: [Excel] Count cells with a red background? 2kmaro  is right. Both websites are great ideas on how to do this.
I would caution you on this though. I made a UDF that counts by color and it fails on some of the colors going between Excel 2010 and 2013 especially on the Reds that change to Orange in 2013, so it's not perfect.
Also all it would take even if you didn't change Excel versions is for one or more cells to be formatted with a ever so slightly different color that you don't or can't distinguish and then you have incorrect totals.
--
He is no fool who gives up what he cannot keep, to gain what he cannot lose. - Jim Elliot |
