Hi there,

Basically i want cell F6 to change colour if cell F5 reads "Failed". I
can't seem to get the formula right!

I don't know if it makes a difference but in cell F5 i have used the
Validation function with a list of 2 options: Failed and successfull.

Any help would be greatly received, cheers

James