Calculations based on cell colour

Hi,
I have a spread sheet which uses conditional formating to turn a cell colour red if the customer is overdue on payment.

Is there a way of adding the values in the red cells only?


Regards,
Stewie

Hi,
Could you clarify what exactly you want to get? From what you write, I understand that you have your cell only red or ...................?

Hi, I am using conditional foramting to change cell colours to "red", late payment, "yellow" payment not due, "green" paid, "blue" invoice needs to be raised, not sent.

I am looking to add the values stated in the red cells only,

Regards,
Steve

Hi there,

No, there is no native way to do this. You could use VBA if you wanted, but it would seem easier to use a formula based on the same criteria as your conditional formatting...

The example will look at A1:A10, and for each value where it equals "late payment" it will sum the adjacent value in B1:B10.

HTH