Calculations based on cell colour

[Stewie]

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

[k0st4din]

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

[Stewie]

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

[Zack Barresse]

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...

=SUMIF( RangeToLookAt, Criteria, RangeToSum)

i.e.
=SUMIF(A1:A10,"late payment",B1:B10)

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