View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.