Previous Topic Next Topic

Conditional Formatting Question

Solved/Closed
J - 10 Oct 2011 à 09:51
 ALkoLiq - 24 Feb 2012 à 16:53
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

Réponse 1 / 2
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
11 Oct 2011 à 08:59
Hi J,

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

So the formula you are looking for is: 
=$A$1<>""
Best regards,
Trowa
Réponse 2 / 2
ALkoLiq
24 Feb 2012 à 16:53
Above one will make an border even if A1 contain numbers so formula for that should be:

=ISTEXT(A1)

Regards
ALkoLiq

Similar discussions

My account locked connect to gemail
Karthik -
winko -

2 responses
Keyboard troubles
jimbobjoe -
car -

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

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response