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