CODEWITHSUNDEEP
excelexcel-formulaexcel-2013
user3084512
user3084512

Reputation: 11

How to create an Excel formula that is dependant on cell color

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.

Upvotes: 1

Views: 4699

Answers (1)

teylyn
teylyn

Reputation: 35915

Color is not data.

If you already have conditional formatting in place, use logic along the same lines to create the sum.

Upvotes: 1

Related Questions