ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Calculating percentage of Shaded Cells in a row (https://www.excelbanter.com/excel-worksheet-functions/181623-calculating-percentage-shaded-cells-row.html)

BrettPotts

Calculating percentage of Shaded Cells in a row
 
I am trying to calculate the number of shaded cells v's none shaded cells in
a row. There is no data in the cells only black shaded cells or uncoloured
cells.

Gary''s Student

Calculating percentage of Shaded Cells in a row
 
see:

http://www.cpearson.com/excel/colors.aspx
--
Gary''s Student - gsnu200776


"BrettPotts" wrote:

I am trying to calculate the number of shaded cells v's none shaded cells in
a row. There is no data in the cells only black shaded cells or uncoloured
cells.



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

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