Conditional formatting based on another cell
Cheers Steve,
Works a treat mate.
"Shaggyjh" wrote:
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
|