Previous Topic Next Topic

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

Answer 1 / 2
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
Answer 2 / 2

Above one will make an border even if A1 contain numbers so formula for that should be:

=ISTEXT(A1)

Regards
ALkoLiq
Ask a question