You need the Formula Is, rather than Cell value Is, option in CF.
--
David Biddulph

"samy" wrote in message
...

Hello,

I have column J & B, when ever i type "Completed" in any cell in column J
i
want the cell in B to turn green.
--
samy