View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dribler2 dribler2 is offline
external usenet poster
 
Posts: 96
Default any link or formula to count cells with same color

To anyone helpful,
i have been trapped by a long formulation in order to list down series of
numbers. Yet due to conditional formatting with If(or conditions, the cells
has been provided with colors. My boss like me to count all the green ones
and the red ones in a single fire.

Please help me to count this long list of varying colored cells. My boss had
made an if formula on all the cells and he can instantly, change all the
colors in a single stroke.

anybody, please just try one shot'
happy holidays
dribler2