Snasui Excel Forum

Hi Dear,

I need your support for Conditional Formatting ignoring space and special characters
Example cell A1,A2,A3 store as below
ABC
A B C
A-B-C
Consider those as duplicate values.how is the formula?

TY

...

Try this in the edit formatting rule window.

=$A$1=SUBSTITUTE(SUBSTITUTE(A1," ",""),"-","")

I hope this may help you.

Norkaz

TY