View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
robnsd robnsd is offline
external usenet poster
 
Posts: 13
Default Count if a cell has color shading

Is there a way to count a cell if it has color shading? I have no
values in my cells, but they are either shaded a color or not. I only
want to count the cells that have color shading in the range I select.
Is this possible? I would rather not enter values or text in the cells
to count them.