Multiple conditional formatting rules

Hello, I'm struggling to create the conditional formatting on an excel sheet for a training record I've created. Any help would be greatly appreciated!   I'm creating a training matrix where the c...