Results 1 to 4 of 4

Thread: Calculations based on cell colour

  1. #1

    Calculations based on cell colour



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Seeker k0st4din's Avatar
    Join Date
    Aug 2012
    Location
    BG, London
    Posts
    6
    Articles
    0
    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.

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

  4. #4
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    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...

    Code:
    =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
    Regards,
    Zack Barresse

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •