Hi,

Can anyone pls help me to solve the below
question?

I've 2 columns typed with the respective header:Ref No(Column C) and
Amount ( Column H).
I 'd like to check whether Ref No in column C corresponding with the
amount in column H are duplicate in these columns. If there is
duplicate then highlight the cell with colors.
The COUNTIF function is working fine for the above situation but it
fails to detect the following values, particularly with blank space in
between the value in Ref No column although they are considered the
same number or duplicate :-

Ref No Amount
A BOT 987415 $250.00
B BOT987415 $250.00
C BOT 987415 $250.00

Is there anyway that can help to solve the above either excel VBA or
excel function? ( ie to give the same solution as COUNTIF function )

Thanks in advance.
Rgds
Lenard,