Forum Discussion

DarranHurd's avatar
DarranHurd
Copper Contributor
Apr 04, 2024

IF function

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 

    • DarranHurd's avatar
      DarranHurd
      Copper Contributor
      Many thanks, perfect.
      Highlight Cells Rules, Text that Contains has worked great.
      Darran

Resources