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?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.