My apologies. I was using copy and paste function instead of fill down from first cell in each row. There should be the correct number of conditional formats. The MOD(Row(),2) was from a different post you had, which I took out after realizing its function.

I have to sift over 1,200 users accounts to ensure they are compliant. A company website spits out the raw data, but I have to sift through manually to see if they are compliant. (i.e, annual date expired, they have the document yes/no) it takes hours looking through this way.

Instead I copy and paste the data, and I can visually see red bad, name turns red because they aren't compliant, and then I can see which of the four criteria is making them non compliant.

1. Do you know how to make the name green or red according to the other columns?
2. If I copy and paste raw data into the spreadsheet it sometimes has blank cells where they haven't uploaded the training document. I want the cell to know if its blank to turn red and say "upload document"

I put notes in A3, A4, and B5 in the spreadsheet to clarify better. Thanks

Date Seperator_CF Clean.xlsx