Forum Discussion
DarranHurd
Apr 04, 2024Copper Contributor
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
- Tanya DentonSteel ContributorUse conditional formatting rules.
- DarranHurdCopper ContributorMany thanks, perfect.
Highlight Cells Rules, Text that Contains has worked great.
Darran