Hey guys! I am a new user trying to learn more about the functions of Excel. I currently am working on a project where I have the results of business accounts and their performances on a month to month basis. I have conditional formatting in place that will automatically tell me if the account has a quantity of 0 (red), 1 (yellow), and more than 1 (green). My next mission is to make sure that all the cells in red automatically goes to a seperate spreadsheet. The yellow cells will automatically go to another spreadsheet and the green cells will also populate information on another spreadsheet. I know I can do this manually, but I'm trying to figure out a way to set it up so that they can do it automatically; it can trigger based on the results.
Is there a possible way to do this and I will greatly appreciate some information or tips on how to do this.
Thank you for your time and I appreciate all the assistance.
Is there a possible way to do this and I will greatly appreciate some information or tips on how to do this.
Thank you for your time and I appreciate all the assistance.
