I want to find out the duplicate and highlights as attached file, who can kindly help me please!
I want to find out the duplicate and highlights as attached file, who can kindly help me please!
In conditional formatting, use the following:
[VBA]=IF(E19="","",COUNTIF(E:E,E19)>1)[/VBA]
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
Thank you lynnow very much but i want to use vba code! Can you help me?
Posting Permissions
Reply With Quote
