Combine the cells.... like so... A1&B1&C1 etc.... then use COUNTIF with the coniditional formatting. For example in G2 put =A2&B2&C2&D2&E2 (you can hide column H). Then for the conditional formatting start at A2 and use formula =IF(A2<>"",IF(COUNTIF($G:$G, $G2)>1,TRUE,FALSE))
On Feb 24, 9:35 am, "John A. Smith" <johnasmit...@gmail.com> wrote: > Your kind help please. > > I have a database that I need to see duplicated rows but can't filter > because some columns can legitimately repeat. If the entire row is a > duplicate, I need to know. > > Please see attached example. Thanking you in advance for your continuing > help in learning Excel. > > John > > Highlight Duplicated Rows Example.xls > 24KViewDownload -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel