Selecting specific cells
 

I haven't been able to figure out this request from a customer... Any
suggestions/thoughts would be appreciated...

Customer Request:
I have a workbook with a column of numbers. Some of the numbers are Fill
Colored. I want a count of the ones with the Fill Color.

I thought of using the countif function but don't know how to express the
color for the formula criteria. Countif(range, criteria).

Will a solution require Visual Basic? I am not competent with VBA.

Selecting specific cells
 

See:

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


--
Gary''s Student - gsnu200773


"Michelle" wrote:

I haven't been able to figure out this request from a customer... Any
suggestions/thoughts would be appreciated...

Customer Request:
I have a workbook with a column of numbers. Some of the numbers are Fill
Colored. I want a count of the ones with the Fill Color.

I thought of using the countif function but don't know how to express the
color for the formula criteria. Countif(range, criteria).

Will a solution require Visual Basic? I am not competent with VBA.