I have a calibration list that has due dates and a column for completion that is marked with an "X" when done. I want excel to automatically find all rows of data that have a date before today (past due) and not complete (no "X" in complete column) and copy them to a second tab labeled "Out of Calibration". Additionally it would be nice to change the color of the "Out of Calibration" tab to red (if that's possible) if any data is present and only transfer certain columns from the transferred row. Can someone help me with how to accomplish this? I'd appreciate any help I can get. Thanks.
Bookmarks