IF function

Copper Contributor

Hello All

I'm sure this is basic but I am struggling. I have this so far 

IF(A1=B1,"OK","ERROR") which works fine.

But, I would like OK to be blue in colour and ERROR to be red, both currently black.

 

Any help gratefully apricated

 

Thanks

Darran 

2 Replies
Use conditional formatting rules.
Many thanks, perfect.
Highlight Cells Rules, Text that Contains has worked great.
Darran