Excel Function make calculations using fill color as identifier?
 

Is there a way to use the fill color in cells to create calculations rather
than the grid identifier system?

Thanks

Excel Function make calculations using fill color as identifier?
 

Please give us an example.

If you want to sum by color for example you need to write a vba routine.

--
Thanks,
Shane Devenshire


"wccjr" wrote:

Is there a way to use the fill color in cells to create calculations rather
than the grid identifier system?

Thanks

Excel Function make calculations using fill color as identifier?
 

Unless he/she is using 2007, then one can use SUBTOTAL and filter by colour


--
Regards,

Peo Sjoblom




"ShaneDevenshire" wrote in
message ...
Please give us an example.

If you want to sum by color for example you need to write a vba routine.

--
Thanks,
Shane Devenshire


"wccjr" wrote:

Is there a way to use the fill color in cells to create calculations
rather
than the grid identifier system?

Thanks