Conditional formatting to clean duplicates values?

I am using excel 2010
I know that I can highlight duplicates using conditional formatting
but is it possible to clean duplicate values with conditional formatting?

I know that i can use data~>delete duplicates, but this remove the duplicates AND the cells that contain them. But how can I simply clean the duplicates values WITHOUT deleting the cell?

any one knows?...
PLEASE I NEED THIS HELP SO MUCH

Conditional formatting can not delete contents of the cell.
it can only format it as you like (colors, icons...)

Originally Posted by zbor

Conditional formatting can not delete contents of the cell.
it can only format it as you like (colors, icons...)

Thanks zbor,
well, maybe you know other way that can help me?
on the attached file, all i need is to remove duplicates from column b AND also (only in the same rows) remove the values in column a
any idea?

By remove duplicated value does it mean you need to remove all (remaining 0) or you need to leave first (remaining 1 that become unique)?

In other words if you have list 1,1,2 do you need result as 1,2 or only 2?

step 1: on column b, i need to leave only the first instance but delete all other instances of the same value
step 2: then, only on same rows we removed the values from column b - i need to remove also the values from column a

Originally Posted by zbor

By remove duplicated value does it mean you need to remove all (remaining 0) or you need to leave first (remaining 1 that become unique)?

In other words if you have list 1,1,2 do you need result as 1,2 or only 2?

zbor (or any other excel professional here),
could you just let me know if its possible to do such thing in excel?
many thanks

Here, try this macro:

Please Login or Register  to view this content.

thank you so much friend!

Originally Posted by zbor

Here, try this macro:

Please Login or Register  to view this content.