PDA

View Full Version : Please kindly help!



vunhai
06-28-2012, 02:09 AM
I want to find out the duplicate and highlights as attached file, who can kindly help me please!

lynnnow
06-28-2012, 02:18 AM
In conditional formatting, use the following:

=IF(E19="","",COUNTIF(E:E,E19)>1)

Change "E:E" to the column you are using and "E19" will be the cell you are entering the conditional format. As for the different colors for different values look here... http://www.xldynamic.com/source/xld.CFConditions.html

vunhai
06-28-2012, 02:30 AM
Thank you lynnow very much but i want to use vba code! Can you help me?