Excel Column Conditional Formatting

I am working in an excel that gets updated daily. We are tracking daily values for metrics for a sports team (think training load, distance, etc.) I have conditional formatting for each individual day's column to identify those who are -2/-1/+1/+2 standard deviations from the team average with color coding so we can see who to rest more or can do extra conditioning. I need it to just pull that day when formatting the column. I managed to get the file set up and the rules set, but now when I add a new day's data, previous days' data are being affected and changing, and I believe being included as part of the average. I've been manually copy and pasting an individual day's formatting across and updating the entire sheet daily to fix it, but is there an easier way to stop this from happening?