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