comparing cells - how?

I need to compare two cells and color them if different, but not
compare spaces.
I've tried the following:

Conditional formating:
=B10<>C10 // But it compares spaces

Formula:
=IF(C10<>B10,"","Different") // But it will compare spaces and I don't
know how to make it color fill C10 & B10

=exact(C10,B10) // But it will compare spaces and I don't know how to
make it color fill C10 & B10 when false

I'm afraid I am way over my head in this. Is there a way to move the
contents of a cell to a buffer,
remove spaces, make it all the same case, then compare to another?
Does anyone have a macro that already does this?

Any help at all would be greatly appreciated before I pull out the few
brown hairs I have left!!

=AND(C10<>"",B10<>"",C10<>B10)

HTH
--
AP

"Nooby" <stwilson@writeme.com> a écrit dans le message de news:
1148049738.653541.163560@j73g2000cwa.googlegroups.com...
>I need to compare two cells and color them if different, but not
> compare spaces.
> I've tried the following:
>
> Conditional formating:
> =B10<>C10 // But it compares spaces
>
> Formula:
> =IF(C10<>B10,"","Different") // But it will compare spaces and I don't
> know how to make it color fill C10 & B10
>
> =exact(C10,B10) // But it will compare spaces and I don't know how to
> make it color fill C10 & B10 when false
>
> I'm afraid I am way over my head in this. Is there a way to move the
> contents of a cell to a buffer,
> remove spaces, make it all the same case, then compare to another?
> Does anyone have a macro that already does this?
>
> Any help at all would be greatly appreciated before I pull out the few
> brown hairs I have left!!
>

I appreciate your help, and it adds to my limited knowledge, but that
formula still does not ignore spaces.
I need the following to be equal: "word" and "wo rd" and "WORD" and
"word"
but not "word" and "wordx"
I added your formula to the conditional formatting.That is where it
goes, right? Maybe it just needs tweaking?

=SUBSTITUTE(B10," ","")<>SUBSTITUTE(C10," ","")

HTH
--
AP

"Nooby" <stwilson@writeme.com> a écrit dans le message de news:
1148051625.329340.29600@y43g2000cwc.googlegroups.com...
>I appreciate your help, and it adds to my limited knowledge, but that
> formula still does not ignore spaces.
> I need the following to be equal: "word" and "wo rd" and "WORD" and
> "word"
> but not "word" and "wordx"
> I added your formula to the conditional formatting.That is where it
> goes, right? Maybe it just needs tweaking?
>

OK. how? Do I add the substitue as formula 1 and the AND as formula 2
to conditional formatting?

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?
>