I have a spreadsheet that will contain about 2000 rows to it and I need to be able to search all of the rows and add data according to certain criteria. For instance I need to search cells A95:C2000, looking for the following in column A: VA, AT, CT, AC. I then need to add a row right under where the previous entry was located along with highlighting the “C” cell associated with the “A” cell. The row that needs to be added needs to contain HS in the “A” cell, a copy of the “B” cell, and a different cell color, like red for the “C” cell. Please help. I will email you a copy of my spreadsheet. Thanks.