View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rui Rui is offline
external usenet poster
 
Posts: 7
Default How do I calculate number of colored cells?

Hi to master gurus in excel,

I really need your help to solve one issue: how to calculate number of
collor cells?

For instance, from cells range A2:F2 (6 cells),if there are 2 cells filled
in any colors, the counter in cell G2 should be equal to 4(6-2).

Any thoughts?
--
Thanks in advance!