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