Conditional Formatting ???

[Orangeanorak]

Can you please give me the formula for the following

If cell A1 contains the words Gift Aid turn cell B1 blue




Many thanks for your help

 

[Norie]

Select B1 and goto Format>Conditional Formatting, pick Formula is and try this:

=(B1="Gift Aid")

and then chose the formatting you want.

 

[Orangeanorak]

Thanks Norie