This Excel video tutorial explains how to test whether a cell contains a text value. The tutorial features the ISTEXT function and the IF function. You can also use the ISTEXT function for conditional formatting which is also explained!
------------------------