Previous Topic Next Topic

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

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
Answer 2 / 2
ALkoLiq
Feb 24, 2012 at 04:53 PM
Above one will make an border even if A1 contain numbers so formula for that should be:

=ISTEXT(A1)

Regards
ALkoLiq
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Keyboard troubles
jimbobjoe -
car -

38 responses
My account locked connect to gemail
Karthik -
winko -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
What shall i do after formatting my laptop?
upen91 -
jack4rall -

1 response