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

Conditional Formatting Question
Apply conditional formatting to the selected cells ✓ - Excel Forum
Yahoo mail forgot password and security question - Guide
This question is locked and replying has been disabled. - Facebook Forum
How to clear formatting in excel - Guide
Excel conditional formatting if another cell contains specific text - Excel Forum

2 responses

Answer 1 / 2

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

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

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Keyboard troubles

Highlight cell if another cell contains any text

one cell will turn green when the two other cells match

Similar discussions

Subscribe To Our Newsletter!