Applying same conditional format per column

HI there - I wonder if you would consider looking at the problem a different way? I'm kind of new myself, so here's how I would approach it - essentially this allows you to create only a handful of rules instead of a new one for each column/date across your grid.

I have recreated your table and used a form to solve the basics - essentially it looks like the below screenshot.

By using a form, you can enter the data using checkboxes to indicate if the dept has attended; the date column is formatted "created date" to show when the form entered the data, and dept's across the top allow for less busy of a sheet.

I used regular formatting to make the default "red" for unchecked, and conditional formatting to change the BG color to green when checked; simply "clone rule" and change the column ID's to match accordingly (watch how many checkmarks you are applying, this can be tricky)

The form will auto record the created date and you could simply select the checkboxes at your daily/weekly meeting, along with other cool stuff on the settings and logic areas of the form.

PS, when testing the form, don't forget to "open form" at the top right-hand of the screen (this used to get me all the time).

Hope this helps, good luck!