conditional formating in adjacent cells

[LISAISAAC]

Hi
Really hoping someone can help, been up many hours trying to sort this.
Basically I want to know how to use conditional formatting for adjacen
cells.

i.e

If cell A1 contains any text then make cell C4 blue

the above is just an example and will want to format C4 to a specifie
colour at a later date. Very new to vba and conditional formating s
please be gentle.

:-

 

[Gord Dibben]

Select C4 then CF>Formula is or Use a Formula(2007 and later)

Enter =ISTEXT(A1)

Format to blue.


Gord

 

[Gord Dibben]

If by "text" you mean anything, not just text...........

=NOT(ISBLANK(A1))


Gord