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

Enter =ISTEXT(A1)

Format to blue.


Gord


On Sun, 22 Apr 2012 09:06:50 +0000, LISAISAAC
wrote:


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 adjacent
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 specified
colour at a later date. Very new to vba and conditional formating so
please be gentle.

:-)