ExcelBanter - Count of colored excel Rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count of colored excel Rows (https://www.excelbanter.com/excel-discussion-misc-queries/445455-count-colored-excel-rows.html)

Moideen

Count of colored excel Rows

Hi,

Please help me to get count of colored excel Rows

Data Having 125 Rows, Row No : 50 and Row No : 75 are colored with blue

When opening the file Need Message How many rows are colored

Please Help me.

Spencer101

Quote:

Originally Posted by Moideen (Post 1599726)

I think counting cells based on bacground colour has to be done with VBA. Try this:

http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

All times are GMT +1. The time now is 06:51 PM.