I need to create a spread sheet with a couple of feature.
We need to work between 3 sheets,
This will contain our product codes and general info about the product such as price and when we have an order come in we will use column F to list the quantities required.
This will also contain our product codes but only those we have in stock
If a quantity is entered into sheet 1 next to a product code then I want the row displayed in sheet 3, if it's an item we have in stock then the background will be green, if we need to order the product the background goes red?
Is this possible?