Hi Michelle,

Am Sat, 30 Jul 2011 07:31:26 -0700 (PDT) schrieb mjones:

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.

I would do it with conditional formatting. Select K7:AH138 = Format =
Coditional Formatting = Formula:
=AND(ISNUMBER($K7),COUNTIF($AD7:$AH7,"Collect payment/update payment method")<5)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2