Re: $$Excel-Macros$$ Conditional Format Duplicate Rows

2011-03-05 Thread NRao Mynampati
On Sun, Feb 27, 2011 at 12:21 AM, John A. Smith wrote: > This is excellent. Thank you for your help. > > John > > > On Thu, Feb 24, 2011 at 11:07 PM, Rohan Young wrote: > >> Hi, >> >> see the attachment if it help >> >> thanks & regds, >> >> ROHAN >> >> >> On Thu, Feb 24, 2011 at 8:05 PM, John A.

Re: $$Excel-Macros$$ Conditional Format Duplicate Rows

2011-02-26 Thread John A. Smith
This is excellent. Thank you for your help. John On Thu, Feb 24, 2011 at 11:07 PM, Rohan Young wrote: > Hi, > > see the attachment if it help > > thanks & regds, > > ROHAN > > > On Thu, Feb 24, 2011 at 8:05 PM, John A. Smith wrote: > >> Your kind help please. >> >> I have a database that I nee

Re: $$Excel-Macros$$ Conditional Format Duplicate Rows

2011-02-24 Thread Rohan Young
Hi, see the attachment if it help thanks & regds, ROHAN On Thu, Feb 24, 2011 at 8:05 PM, John A. Smith 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,

$$Excel-Macros$$ Conditional Format Duplicate Rows

2011-02-24 Thread Jason Henke
Using conditional formatting it seems to work like this. Select your range and then on the conditional formatting menu change to Formula and insert the below formula, pick how you want it highlighted. =COUNTIF($A$2:$E$5000,A2:IS2)>1 I'm no expert, but I was able to figure it out. Perhaps one of t

$$Excel-Macros$$ Conditional Format Duplicate Rows

2011-02-24 Thread John A. Smith
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 --