title: How to create an Excel formula that is dependant on cell color
body: <p>I have a row of cells colored green containing actual payments and yellow cells containing the amount intended to pay. In column A I have the total currently owed for a given invoice. What I need is to be able to subtract the contents of any cell colored green from the invoice amount in column A.</p>