View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sheeba sheeba is offline
external usenet poster
 
Posts: 9
Default Count no of rows with interior color

Hello!


Is it possible to count the nuber of rows in a range with interior
color (any)

for eg. on range "B1:F20" if any cell in B1:F1 got interior color count
it and check next row B2:F2 ... like wise and count the number of rows
in the range having atleast one cell with interior color.

thanks