Conditional formatting using text

's Computer Specifications

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?

--
Kind regards, Nic

's Computer Specifications

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
---------------
Jacob Skaria

"Nic Daniels" wrote:

> 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?
>
> --
> Kind regards, Nic

's Computer Specifications

Thank you!
--
Kind regards, Nic

"Jacob Skaria" wrote:

> 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
> ---------------
> Jacob Skaria
>
>
> "Nic Daniels" wrote:
>
> > 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?
> >
> > --
> > Kind regards, Nic

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Text in Conditional formatting	Dave White	Microsoft Excel Misc	5	13th Mar 2009 07:13 AM
Conditional Formatting of text effecting formatting of background	=?Utf-8?B?SEFI?=	Microsoft Access Reports	6	25th Mar 2008 06:23 PM
Conditional Formatting based on text within a cell w/ text AND num	=?Utf-8?B?U2hpcmxleQ==?=	Microsoft Excel Worksheet Functions	2	22nd Dec 2006 01:40 AM
conditional formatting text	=?Utf-8?B?a2F0ZQ==?=	Microsoft Excel Worksheet Functions	4	1st Sep 2006 03:45 PM
Conditional Formatting based on Text within Text	=?Utf-8?B?R2VvcmdlIEx5bmNo?=	Microsoft Excel Misc	3	5th May 2005 07:58 PM