Conditional Formatting or Formulas in a new column to see modifications

[Nurseryboy]

Hi,

I have a question/dilemma that I need a little guidance on (no Macros or VBA please). I’m trying to figure out what the best way to do this. Let me explain…

I work on a large spreadsheet on which I need to make modifications (see sample attached spreadsheet) and then upload the modified file to an online database. There is currently some Conditional Formatting in this sheet and I’m trying to figure out if it’s better to use more Conditional Formatting or formulas to see modifications from sheet to sheet.

Only the following Columns will ever have “manual” edits:
- Column B (Listing)
- Column C (Price 1)
- Column D (Price 2)
- Column F (Model)

I want to be able to “pick out” the modified items quickly (via a Custom Sort), so I can upload only that portion of the overall list. In other words, “Sort by” a certain parameter where the modified Items would come to the top of the list, so instead of me needing to upload the entire list of thousands of Items, I can do a “partial update” with only the modified Items.

I’ve made some manual modifications on the “Current Day” tab (different from “Previous Day” tab) to show what are some of the changes that would be made.

Additional Info:
- After I make modifications on the “Current Day” tab and make the necessary upload, that tab becomes “Previous Day”, in which I “copy and paste as text” to “lock in” all the values to use as a “snapshot in time”. I do this for every subsequent tab, so if there is anything that doesn’t go right, I can see exactly when any mistakes were made. Thus, eventually, I will have the following tabs: “Previous Day”, “11-20-15”, “11-19-15”, “11-18,-15”, etc.
- However, the only tabs that are “interacting” at any one time are the “Current Day”, “Data 11-30-15”, “Inv 11-30-15” and “Previous Day”. All the other tabs are just for future data checking.
- I keep all of my previous tabs in the same spreadsheet for about a month or so, when I archive that month’s uploads into a separate “Archive file”.
- I keep this file open in Excel (in the background) all the time, so it can’t take up too much background memory for calculations.

Please let me know any of your thoughts. Thank you very much in advance.

Yury