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,
Could you clarify what exactly you want to get? From what you write, I understand that you have your cell only red or ...................?
There is no greater pleasure than knowing you have an unknown friend who would have responded to help you when you need it.
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.Code:=SUMIF( RangeToLookAt, Criteria, RangeToSum) i.e. =SUMIF(A1:A10,"late payment",B1:B10)
HTH
Regards,
Zack Barresse
Bookmarks