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