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 bla...
Tanya Denton
Steel Contributor
Use conditional formatting rules.
DarranHurd
Apr 04, 2024Copper Contributor
Many thanks, perfect.
Highlight Cells Rules, Text that Contains has worked great.
Darran
Highlight Cells Rules, Text that Contains has worked great.
Darran