See http://www.contextures.com/xlCondFormat01.html

--
__________________________________
HTH

Bob

"Alexz" wrote in message
...
I have several very large worksheets in which I need to find the following
information:

The criteria would be as follows:
Incuded in the worksheet are two columns: "sales" and "amount". If the
numbers in the "sales" and "amount" columns are inconsistent, meaning if
there is a number that is positive in one column and negative in the
other, I
need to find a way to highlight, or extract toa separate worksheet, those
rows.



Sales Amt.