I would like to create a function where conditional formatting rules are being applied whenever a particular sheet is being edited. Basically, I have a form recieving data, and then I have a script and formulas working to add a check mark to a sheet if the data has been submitted

I have a google form that has a few different inputs that goes to a google sheet. One of the inputs is the name of the person filling out the form. I have created a tab for each user (about 170) and set it up so that each time there’s an entry then a query function sorts the data into the respective tab. I’ve tried using a macro to write a script to highlight data from the past seven days in one color and the past six weeks in another color. The second function recreates the formatting for each tab but it takes too long and I can only get about 1/4 of the way within whatever time limit is enforced by appscript. Am I missing something or is there an easier way to do this so I don’t have to manually do this for all 170 tabs?