Conditional Formatting Question

[Solved/Closed]
Report
-
 ALkoLiq -
Hello,

I am trying to create a formula for the following:

If there is any text in cell A1, there is a border around cell B3.

I know I need to use conditional formatting, but am unsure of what formula to use. Can anyone help?

Thanks,
J

2 replies

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi J,

The opposite of "=" is "<>".

So the formula you are looking for is:
=$A$1<>""
Best regards,
Trowa
Above one will make an border even if A1 contain numbers so formula for that should be:

=ISTEXT(A1)

Regards
ALkoLiq