Conditional formatting using text

  • Thread starter Thread starter Nic Daniels
  • Start date Start date
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?
 
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
 
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...
 
Back
Top