Condtional Formatting Highlight if not on another sheet

[ZHertz]

Hi Everyone,

I am trying to use condtional formatting to highlight a row in a table if the order number is NOT on another table, on a different sheet.
Example:
Order Number 1001 is in my table on Sheet4, Once the order has been filled is comes off my "Pending Orders" table on Sheet1, which is based on a data connection, so it updates once the connection is refreshed. I would like the row with order number 1001 in my table on Sheet4 to be highlighted letting me know it can now be removed, since I have to manually manage this table. I am using Excel 2010.

Thanks for your help!

-Zach

 

[kevatarvind]

can you upload you sample file where you want to use conditional format and which criteria ?

 

[ZHertz]

I tried searching the help page to see how to upload a sample file, but it says its not possible??

 

[kevatarvind]

upload file any other sharing site like dropbox or mediafire or 4shared and paste only link here