ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Count Highlighted cells (https://www.excelbanter.com/excel-programming/310580-count-highlighted-cells.html)

DME

Count Highlighted cells
 
Is there a formula or VBA program I can use to count the cells that are
highlighted a certain color i.e. # of cells that are highlighted red or
yellow.

Thanks in advance!



Frank Kabel

Count Highlighted cells
 
Hi
see:
http://www.xldynamic.com/source/xld.ColourCounter.html

-----Original Message-----
Is there a formula or VBA program I can use to count the

cells that are
highlighted a certain color i.e. # of cells that are

highlighted red or
yellow.

Thanks in advance!


.


Kris

Count Highlighted cells
 
Hi,

This should give you everything you need to know.

http://www.cpearson.com/excel/colors.htm

Sincerely,

Kris

-----Original Message-----
Is there a formula or VBA program I can use to count the

cells that are
highlighted a certain color i.e. # of cells that are

highlighted red or
yellow.

Thanks in advance!


.



All times are GMT +1. The time now is 12:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com