If applying the CF to say B1:G20 instead of to col A as posted earlier,
just select the target range B1:G20, and change the CF formula
to point to the *top left corner* of the range, i.e. to B1instead of A1

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

The CF formula will adjust itself accordingly within each cell in the range
selected

Alternatively, you can use the format painter to apply
Select any one cell within the conditionally formatted col A, say A3 ?
Double-click on the format painter, then "paint" over the target range
B1:G20
with the cursor as a brush

Press Esc when done to cancel and revert the cursor to normal

--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <atyahoo<dotcom
---
"Kim" wrote in message
...
Thanks,

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

Kim