"mjones" wrote:
Where ANeedToFinalizeColumn is named as =TRANSACTIONS!$AD$7:$AH$138
Where AmountDueToQCPColumn is named as =TRANSACTIONS!$K$7:$K$138

If one of the five "A Need To Finalize Columns" does not have "Collect
payment/update payment method" and there is a number in the "Amount
Due To QCP Column", return "Warning" so we don't forget to collect the
payment.

Please see the discussion in the Microsoft Answers Forum.

For those who want to follow along, PS: go to
http://social.answers.microsoft.com/...ry/officeexcel.