No, you enter the following formula as formula 1
=SUBSTITUTE(B10," ","")<>SUBSTITUTE(C10," ","")

If true (B1=C1, skipping spaces) the formatting takes place


"Nooby" <stwilson@writeme.com> a écrit dans le message de news:
1148052899.859437.249540@i40g2000cwc.googlegroups.com...
> OK. how? Do I add the substitue as formula 1 and the AND as formula 2
> to conditional formatting?
>