Cond Format - C6 when G6 contains any text

[hollies]

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.

 

[Pete_UK]

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

 

[hollies]

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!!!!

 

[Pete_UK]

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

Pete

 

[Tyro]

Books on Excel explain that.

Tyro