Conditional formatting using text

[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?

 

[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

 

[Nic Daniels]

Thank you!
--
Kind regards, Nic

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