S
Steve Wood
Is there a method that I can sum all cells of a certain cell colour? Eg. sum
of all cells colured red? TIA
of all cells colured red? TIA
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
B
Bob Phillips
There is an example of using SUMPRODUCT and UDFs to count coloured cells at
http://www.xldynamic.com/source/xld.ColourCounter.html
The biggest problem is that changing a colour does not generate a worksheet
recalculation. One way around this is to use a button to set the colour, and
in the code associated with the button, do a sheet calculate
(Activesheet.Calculate). You would also need to add Application.Volatile to
the UDF.
--
HTH
RP
(remove nothere from the email address if mailing direct)
http://www.xldynamic.com/source/xld.ColourCounter.html
The biggest problem is that changing a colour does not generate a worksheet
recalculation. One way around this is to use a button to set the colour, and
in the code associated with the button, do a sheet calculate
(Activesheet.Calculate). You would also need to add Application.Volatile to
the UDF.
--
HTH
RP
(remove nothere from the email address if mailing direct)
F
Frank Kabel
Hi
only possible with VBA. See
http://www.xldynamic.com/source/xld.ColourCounter.html
and
http://www.cpearson.com/excel/colors.htm
only possible with VBA. See
http://www.xldynamic.com/source/xld.ColourCounter.html
and
http://www.cpearson.com/excel/colors.htm