I have a business that makes pick ups from customers. I created a database of my customers that predicts the date of the next pick up and then displays that date in a cell next to the customer info. I then created a conditional format that highlights the "date" cell different colours depending on it's proximity to the current date. (ie. when it's highlighted green the pickup date is within two days of the current date and when it is highlighted red it is passed due.).
The problem is that i now have many customers and scrolling through the entire database to find highlighted cells is time consuming. is there a way i can get excel to copy highlighted cells and the cell with the corresponding name of the customer to a separate worksheet?
thanks a bunch
Bookmarks