In the "POs Unsent 2007", the vendor number is in column D, with anywhere
from 1 to 2500 rows. In the "EDI Status Report", the vendor number is in
column A and status is in column C, with anywhere from 1 to 50 rows.

Hope this explains it and many thanks for any and all help.

"squenson via OfficeKB.com" wrote:

I would return with VLOOKUP the vendor status and put it in a separate column
(always easier when you have to sort later on, Excel will not allow sorting
using just colors!), then a conditional formatting on the whole row using
that cell as reference. Excel supports 3 conditional formatting, plus the
default color it makes a maximum of four options. With a macro, you could
have as many colors as you want.

Please give us more details about the position of your vendor code, status in
the sheet, and we will be able to give you exact formulas.

Stephane Quenson.

--
Message posted via http://www.officekb.com