Change in quantity highlighting

[southpaw5271]

Hello, I work for an Automotive Parts supplier and I have a list of all of the parts we have listed on eBay. The excel list includes: Part Numbers, Manufacturer, and current stock we have. I need a way to highlight the products that were in stock and are now out of stock and the parts that were out of stock and are now in stock. I thought about conditional formatting and I think that is still a good way to do it but I will differ to the more knowledgeable community. Please help me find a way to highlight the rows that have changes in stock, preferably in two separate colors. Thank you.

[Special-K]

To know changes in stock you need to know two things: what the stock was before and what it is now.
Lets assume column A is stock before and column B is stock now.

Use condtional formatting as you suggested with the option "use a formula to determine..."
with the formulas

=AND(A1=0,B1<>0)
to indicate items that are now in stock and format as required

Similarly
=AND(A1<>0,B1=0)
to indicate items that are now out of stock and format as required