Excel 2007 Spreadsheet

Hello Linda,

The answer to your question is possible but not without learning VBA coding to achieve this. You could then write a script to detect the various colours then calculate

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer