I'm trying to require text to be entered in cell B1 if there is text in cell A1.
This below formula seems to be close, in that it is giving me TRUE or FALSE, but if it is true i don't want it to display anything, if it is false, I want it to display "Cell B1 must be valued"
=IF(ISTEXT(A1),ISTEXT(B1),"Cell B1 must be valued")
Bookmarks