Thanks,

It turned red alright, but how do I apply to a range of cells? Please advice.

Kim

"Max" wrote:

Try these 3 ways ..
(one of which should hopefully fit what you're after)

Select col A
Click Formatting Conditional Formatting

(A)
Condition 1:
Formula is: =TRIM(A1)="x"
Format Font tab Red/bold
OK out

Above will format any cells in col A
which contain *only* an "x"
(not case-sensitive)

or perhaps ..

(B)
Condition 1:
Formula is: =NOT(ISERROR(FIND("X",A1)))
Format Font tab Red/bold
OK out

Above will format any cells in col A
which contain any text with at least one capital "X"
(Case-sensitive)

(C)
Condition 1:
Formula is: =NOT(ISERROR(SEARCH("X",A1)))
Format Font tab Red/bold
OK out

Above will format any cells in col A
which contain any text with at least one "x"
(non case-sensitive)

--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <atyahoo<dotcom
---
"Kim" wrote in message
...
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