cell pattern - color
hi community
is it possible to count number of cells that has color pattern, what i m saying: example in A1:A5 and I have A1 fill with color pattern A3 fill with color pattern A4 fill with color pattern and I want to check whether in range A1:A5 how many cells have color pattern.. can I do such and if possible, how i do it? thanks community for the help :) -- oldLearner57 |
cell pattern - color
A couple of ways
http://www.ozgrid.com/Excel/count-sum-cell-color.htm http://www.cpearson.com/excel/colors.htm Mike "tikchye_oldLearner57" wrote: hi community is it possible to count number of cells that has color pattern, what i m saying: example in A1:A5 and I have A1 fill with color pattern A3 fill with color pattern A4 fill with color pattern and I want to check whether in range A1:A5 how many cells have color pattern.. can I do such and if possible, how i do it? thanks community for the help :) -- oldLearner57 |
cell pattern - color
See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "tikchye_oldLearner57" wrote in message ... hi community is it possible to count number of cells that has color pattern, what i m saying: example in A1:A5 and I have A1 fill with color pattern A3 fill with color pattern A4 fill with color pattern and I want to check whether in range A1:A5 how many cells have color pattern.. can I do such and if possible, how i do it? thanks community for the help :) -- oldLearner57 |
All times are GMT +1. The time now is 08:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com