Hi,

I have a spreadsheet that is a shift roster and I need to count overtime slots that have been taken. Overtime slots are denoted by the celld being red and having a persons initials in.

Does anyone know how to create a formula that will count the number of cells in a row that are RED in colour and dont contain the letters OT.

Im new to Excel and am completely lost on how to do this.