Color-Coding the Insider List

1. Products to Remove

1. Select the entire list
2. Go to Data>Click on Sort Range

1. Click Data has header row
2. Sort By Definite
3. Click Add another sort column
4. Then by Sep 17 Page   (or whatever the last issues was)
5. Click Sort

3. Scroll down the item list until you get to the last one marked Definite
4. Find any products that have a Sep 17 Page number but are not marked as definite 

1. Put 1R in the Definite column for these products
2. Change the font for these lines to red

2. New Products

1. Select the entire list
2. Go to Data>Click on Sort Range

1. Click Data has header row
2. Sort By New
3. Click Sort

3. Find any products marked as new for Nov2017 (or whatever the current issue is)

1. Put 2N in the Definite column for these products
2. Change the font for these lines to green

3. No Change (products staying from previous issue)

1. Go to Data>Click on Sort Range

1. Click Data has header row
2. Sort By Definite
3. Click Add another sort column
4. Then by Sep 17 Page   (or whatever the last issues was)
5. Click Sort

2. Scroll down the item list until you get past the ones marked 1R or 2N
3. Find any products that have a Sep 17 Page number and are also marked as definite 

1. Put 3NC in the Definite column for these products
2. Leave the font for these lines set to black

4. Add Products (not new and not in previous issue)

1. Go to Data>Click on Sort Range

1. Click Data has header row
2. Sort By Definite

2. Scroll down to products marked definite, but have been set to 1R, 2N, or 3NC

1. Put 4a in the Definite column for these products
2. Change the font for these lines to orange