Make cell turn different colour

[Guest]

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?

 

[Guest]

what was the if statement you used?
actually you dont need an if statement

what happens if there is a C in one cell and and R in another?
If there can only be one
try
countif(C1:AF1,"C")>0
for your formula is in conditional formatting

and similar for the other two colors

If there can be more than one, make sure you have your order set up properly
in conditional formating

 

[Guest]

Hi bj

Many many thanks for that.

It works a treat!