Hi L K Modi,
your query is not clear. Please elaborate.
Kalyan
On Wed, Jul 6, 2011 at 5:06 PM, ankur wrote:
> *HI LK MODI
> USED SUM BASED ON "COLOUR OF CELL" , MAY THIS HELP YOU
> USE THIS UDF, U CAN SEE THE CODE IN MODULE
>
>
> =ColorFunction($B$30,$B$2:$B$27,TRUE)
> WHERE B30 CELL IS HAVIN
use conditional format with formula
=indirect("B" & row())<>""
pls find file attached.
cells containg amounts out of those some
> cells are coloured.
>
> Is there any way to coloured only those coloured cells. One way i have by
> filter on the basis of colour but everytime to use that is hectic s
http://akoul.blogspot.com/search/label/Function%20To%20Sum%20cells%20on%20the%20basis%20of%20font%20color
http://akoul.blogspot.com/search/label/Function%20To%20Count%20cells%20on%20the%20basis%20of%20font%20color
On Wed, Jul 6, 2011 at 5:06 PM, ankur wrote:
> *HI LK MODI
> USED SUM BASED ON
*HI LK MODI
USED SUM BASED ON "COLOUR OF CELL" , MAY THIS HELP YOU
USE THIS UDF, U CAN SEE THE CODE IN MODULE
=ColorFunction($B$30,$B$2:$B$27,TRUE)
WHERE B30 CELL IS HAVING COLOUR OF THE CONDITIONAL FORMATING
FILE IS ATTACHED FOR UR REFERENCE
*Have A Nice Time & Enjoy Life
Regards:
CMA Ankur P
