Complicated conditional formatting problem.

Here's my situation:

I have a sheet with a query on it, and aanother sheet with manual data in it. I have set both as ranges, and pull the information from both into a pivot table on another sheet using multiple consolidations. The issue at hand is that when a new value is pulled into the query, it obviously isn't put on the manual tab. What I want to happen, if possible, is to have a cell turn red to show that the value is in the query, but not in the manual tab.

Is there a way to write a formula that says, if a certain value is on one sheet and not another, it will bring up an error, and therefore allow me to set a conditional format that turns the cell red?

Thanks for any help!

Apply Conditional Formatting using defined named ranges between sheets.
http://www.cpearson.com/excel/cformatting.htm#DefName

Thanks a lot!