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 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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