|
Posted to microsoft.public.excel.misc
|
|
|
any link or formula to count cells with same color
See:
http://www.cpearson.com/excel/colors.htm
--
Gary's Student
"dribler2" wrote:
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
|