Creating simple yes or no formula for an audit [closed]
Solution 1:
Conditional Format
In the image attached is this what you are trying to achieved? Then create two conditional format with formula insert the below formula and the color you wanted to use, in this case you want to be Green and Red.
=ISNONTEXT(B3)=TRUE =ISNONTEXT(B3)=FALSE