Conditional formatting using text

N

Nic Daniels

Hi,

I want to change the background color of cell A1 (A2 etc) into red if the
cell next to it, B1 (B2 etc.) contains any text whatsoever. How do I do that?
 
J

Jacob Skaria

Select Column A. From menu Format>Conditional Formatting>Condition1>Formula Is>

=ISTEXT(B1)

and select the color Red....Click OK

If this post helps click Yes
 
N

Nic Daniels

Thank you!
--
Kind regards, Nic


Jacob Skaria said:
Select Column A. From menu Format>Conditional Formatting>Condition1>Formula Is>

=ISTEXT(B1)

and select the color Red....Click OK

If this post helps click Yes
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting macro: simple, but doesn't work 6
Excel Conditional Formatting 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
macro for copying background color 7
conditional formatting 2
Excel conditional formatting with Weeknum 4
Conditional formatting using relative refrencing 1
Background color change, by using the formula. 1

Top