Cond Format - C6 when G6 contains any text
 

Hi

I have spent a couple of hours reading through previous posts but cannot
seem to find quite what I am looking for.

I want to CF a range of cells in one column depending on there being any
text in the corresponding range of another column.

ie Change the background of any cell in (C6:C41) only if "any" text is put
into the corresponding cell in (G6:G41)

So, if I type any length of text into G19, C19's background will change
colour.

Hope I have explained this OK.
--
Thanks, Rob

Cond Format - C6 when G6 contains any text
 

Highlight cells C6:C41 so that C6 is the active cell, then Format |
Conditional Format, choose Formula Is rather than Cell Content Is, and
then enter this formula:

=G6<""

Click the Format button, then the Patterns tab and choose your colour.
Click OK twice to exit the CF dialogue.

Hope this helps.

Pete

On Jan 20, 12:19*pm, hollies
wrote:
Hi

I have spent a couple of hours reading through previous posts but cannot
seem to find quite what I am looking for.

I want to CF a range of cells in one column depending on there being any
text in the corresponding range of another column.

ie *Change the background of any cell in (C6:C41) only if "any" text is put
into the corresponding cell in *(G6:G41)

So, if I type any length of text into G19, C19's background will change
colour.

Hope I have explained this OK.
--
Thanks, Rob

Cond Format - C6 when G6 contains any text
 

Pete

Many thanks for your swift answer which has worked perfectly and is just
what I was looking for.

You have been a great help.

Here is another difficult question.....why is such an easy solution so hard
to fathom out for an idiot like me!!!!


--
Thanks, Rob


"Pete_UK" wrote:

Highlight cells C6:C41 so that C6 is the active cell, then Format |
Conditional Format, choose Formula Is rather than Cell Content Is, and
then enter this formula:

=G6<""

Click the Format button, then the Patterns tab and choose your colour.
Click OK twice to exit the CF dialogue.

Hope this helps.

Pete

On Jan 20, 12:19 pm, hollies
wrote:
Hi

I have spent a couple of hours reading through previous posts but cannot
seem to find quite what I am looking for.

I want to CF a range of cells in one column depending on there being any
text in the corresponding range of another column.

ie Change the background of any cell in (C6:C41) only if "any" text is put
into the corresponding cell in (G6:G41)

So, if I type any length of text into G19, C19's background will change
colour.

Hope I have explained this OK.
--
Thanks, Rob

Cond Format - C6 when G6 contains any text
 

You're welcome, Rob - thanks for feeding back.

Pete

On Jan 20, 3:41*pm, hollies wrote:
Pete

Many thanks for your swift answer which has worked perfectly and is just
what I was looking for.

You have been a great help.

Here is another difficult question.....why is such an easy solution so hard
to fathom out for an idiot like me!!!!

--
Thanks, Rob



"Pete_UK" wrote:
Highlight cells C6:C41 so that C6 is the active cell, then Format |
Conditional Format, choose Formula Is rather than Cell Content Is, and
then enter this formula:

=G6<""

Click the Format button, then the Patterns tab and choose your colour.
Click OK twice to exit the CF dialogue.

Hope this helps.

Pete

On Jan 20, 12:19 pm, hollies
wrote:
Hi

I have spent a couple of hours reading through previous posts but cannot
seem to find quite what I am looking for.

I want to CF a range of cells in one column depending on there being any
text in the corresponding range of another column.

ie *Change the background of any cell in (C6:C41) only if "any" text is put
into the corresponding cell in *(G6:G41)

So, if I type any length of text into G19, C19's background will change
colour.

Hope I have explained this OK.
--
Thanks, Rob- Hide quoted text -

- Show quoted text -

Cond Format - C6 when G6 contains any text
 

Books on Excel explain that.

Tyro

"hollies" wrote in message
...
Hi

I have spent a couple of hours reading through previous posts but cannot
seem to find quite what I am looking for.

I want to CF a range of cells in one column depending on there being any
text in the corresponding range of another column.

ie Change the background of any cell in (C6:C41) only if "any" text is
put
into the corresponding cell in (G6:G41)

So, if I type any length of text into G19, C19's background will change
colour.

Hope I have explained this OK.
--
Thanks, Rob