Hi

I have a spreadsheet with names in Column A. I want the cell containing the
name to turn RED if there's a "C" in columns C to AF for each row, YELLOW if
there's an "A" and GREEN, if there's an "R".

I've tried using an IF statement in Conditional Formatting and also using a
range = "C" etc, but neither seems to work. Help please?