Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Duplicate entries
I have been using Conditional Formatting to indicate duplicate entries in a
column. This highlights entries seen 2 or more times. This is working well, however the need has expanded to highlight not only duplicates seen for the first two times, but the third or greater time by a different highlight color. This application indicates a warning for the second occurrence, and an action with the third occurrence. Your help would be appreciated. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Duplicate entries
Based on this sample, tell us what cells would be highlighted and with what
color: A1: 1 A2: 1 A3: 1 A4: 1 A5: 1 -- Biff Microsoft Excel MVP "wally" wrote in message ... I have been using Conditional Formatting to indicate duplicate entries in a column. This highlights entries seen 2 or more times. This is working well, however the need has expanded to highlight not only duplicates seen for the first two times, but the third or greater time by a different highlight color. This application indicates a warning for the second occurrence, and an action with the third occurrence. Your help would be appreciated. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Duplicate entries
A1 - no color
A2 thru A5 would be yellow. What I'm looking for is: A1 - no color A2 - Yellow A2 thru A5 - something like red "T. Valko" wrote: Based on this sample, tell us what cells would be highlighted and with what color: A1: 1 A2: 1 A3: 1 A4: 1 A5: 1 -- Biff Microsoft Excel MVP "wally" wrote in message ... I have been using Conditional Formatting to indicate duplicate entries in a column. This highlights entries seen 2 or more times. This is working well, however the need has expanded to highlight not only duplicates seen for the first two times, but the third or greater time by a different highlight color. This application indicates a warning for the second occurrence, and an action with the third occurrence. Your help would be appreciated. . |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Duplicate entries
Ok, try this....
Select the *entire* range Goto FormatConditional Formatting Condition 1 Formula Is: =COUNTIF(A$1:A1,A1)=2 Click the Format button Select the Patterns tab Select the color desired OK Click the Add button Condition 2 Formula Is: =COUNTIF(A$1:A1,A1)2 Click the Format button Select the Patterns tab Select the color desired OK out -- Biff Microsoft Excel MVP "wally" wrote in message ... A1 - no color A2 thru A5 would be yellow. What I'm looking for is: A1 - no color A2 - Yellow A2 thru A5 - something like red "T. Valko" wrote: Based on this sample, tell us what cells would be highlighted and with what color: A1: 1 A2: 1 A3: 1 A4: 1 A5: 1 -- Biff Microsoft Excel MVP "wally" wrote in message ... I have been using Conditional Formatting to indicate duplicate entries in a column. This highlights entries seen 2 or more times. This is working well, however the need has expanded to highlight not only duplicates seen for the first two times, but the third or greater time by a different highlight color. This application indicates a warning for the second occurrence, and an action with the third occurrence. Your help would be appreciated. . |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Duplicate entries
That works. Thanks!!!
I really appreciate what you guys do for us. "wally" wrote: I have been using Conditional Formatting to indicate duplicate entries in a column. This highlights entries seen 2 or more times. This is working well, however the need has expanded to highlight not only duplicates seen for the first two times, but the third or greater time by a different highlight color. This application indicates a warning for the second occurrence, and an action with the third occurrence. Your help would be appreciated. |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Duplicate entries
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "wally" wrote in message ... That works. Thanks!!! I really appreciate what you guys do for us. "wally" wrote: I have been using Conditional Formatting to indicate duplicate entries in a column. This highlights entries seen 2 or more times. This is working well, however the need has expanded to highlight not only duplicates seen for the first two times, but the third or greater time by a different highlight color. This application indicates a warning for the second occurrence, and an action with the third occurrence. Your help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate entries | Excel Worksheet Functions | |||
Duplicate Entries | Excel Discussion (Misc queries) | |||
Duplicate Entries | Excel Discussion (Misc queries) | |||
Getting rid of not quite duplicate entries | Excel Worksheet Functions | |||
Duplicate entries | Excel Worksheet Functions |