Hi again, sorry to be a pain but I have another question and you have been incredibly helpful!

I'm trying to figure out if there is a way to automatically colour code the cells from column F onwards, based on the starting date (column C) of the person in each row. For example, in the originally attached sample spreadsheet, instead of manually changing the colour of H4-AN4 to green (to indicate this is the person's first month), can I use formula-based conditional formatting to do this automatically?

I've tried playing around with it but I cannot seem to figure it out - it seems like the only way to use this is to base the conditional formatting off the content of the cell to be formatted, rather than the content of C4 cross referenced with F2-NF2. I hope this makes sense.