Conditional Formatting Question

Solved/Closed
J - Oct 10, 2011 at 09:51 AM
 ALkoLiq - Feb 24, 2012 at 04:53 PM
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

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
Oct 11, 2011 at 08:59 AM
Hi J,

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

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

=ISTEXT(A1)

Regards
ALkoLiq
0