conditional formatting based on an entire row

Back again since i got good help yesterday...

what im looking to do now is color fill a cell based on the value of an entire row.

What i have is a sheet that shows our current orders. The first column has the order number, which covers two rows. From there, the first row for that order is "Quantity Ordered" and the second row is "Quantity Received". From there, it is about 200 columns long.

What i am looking to do, is have three variables to determine the color of the cell with the order number in it.

1. One color to show the order has not come in yet (basically the received line is empty and does not match the ordered line).
2. One color to show the order is partial (this would be SOME values in the received line match values on the ordered line).
3. One color to show received (this would be when all the values of the received line, match all the values on the ordered line).

thanks again!

P.S. using excel 2007

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

well maybe
condition 1
=COUNT(E4:X4)=0
condition 2
=SUM(E3:X3)<>SUM(E4:X4)
condition 3
=SUM(E3:X3)=SUM(E4:X4)