Govind,
Thanks for your quick reply, I tried typing in something like this in the
(formats, cells, custom) "=if(istext(range),true,[red])" but excel tells me
it can't use the formula, am I missing your drift?
say I want the text colour to be red whenever a cell contains text instead
of number, can you help me more?

Cheers

Kim

"Govind" wrote:

Hi,

Lets say the text is in A1,

Go to conditional formatting,Choose Formula is and type in

=IF(ISTEXT(A1),TRUE,FALSE)

and then choose your format.

Regards

Govind.


Kim wrote:
Hi
Can some one help to setup a conditional format, the condition is turn the
text red when ever the cell contains an "X". I can see the examples given
for numbers but not text and I tried substitute for text but still no joy an
dended up with lots of duff conditions in the examples.
Please help.

Cheers

Kim