View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marc Marc is offline
external usenet poster
 
Posts: 70
Default counting cells based on conditional formatting

hello -

I've conditionally formatted a column of cells to a yellow background based
on the sum of 5 other cells in the row.

Now I want to count the number of yellow cells. I don't know VB, so if
someone knows a formula method to count the cells, that would be great.

Thanks,

Marc