Is there a way to count the number of different colored cells?
I have uniqure colored rows in my excell spreadsheet. Is there a formula to
count the total number of green rows, red rows, blue rows, etc? |
Is there a way to count the number of different colored cells?
You will have to use code; Chip Pearson show how...
http://www.cpearson.com/excel/colors.htm -- Jim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "MCM" wrote in message I have uniqure colored rows in my excell spreadsheet. Is there a formula to count the total number of green rows, red rows, blue rows, etc? |
All times are GMT +1. The time now is 01:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com