Hello,
I am making an automation that creates a data table from data scrapping - stores it into an excel file - then if the word “freshman” appears in a specified column - it is coloring a different cell blue. Everything works great until it goes to color - it delete all of the information in the excel file, but continues to color the excel sheet. How do I get the set range color to not delete the information in the excel file?