Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight Duplicate Data in each Row
Seelect A1:I100 or whatever the last row is
FormatConditional Formatting Change Condition 1 To Formula Is Add a formula of = COUNTIF(1:1,A1)1 Click Format On the Font tab, select a font colour and Bold OK out -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Sum" <vcswong(at)hotmail.com wrote in message ... Hello, I have an Excel table with about 200 rows. Please see the attached GIF file. There are 10 choices for each user. I would like to highlight the duplicate entries that the user chose. After searching from the internet, I can only find the macro to do this "for each coloumn" but not for "for each row". Can anyone teach me the way to do this, please? Thank you very much!! Sum |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight Duplicate Data in each Row
Thanks for your suggestion!
COUNTIF(1:1,A1)1 ................. which cannot work "Bob Phillips" wrote in message ... Seelect A1:I100 or whatever the last row is FormatConditional Formatting Change Condition 1 To Formula Is Add a formula of = COUNTIF(1:1,A1)1 Click Format On the Font tab, select a font colour and Bold OK out -- HTH Bob Phillips |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
highlight duplicate rows | Excel Discussion (Misc queries) | |||
Highlight Duplicate Data in each Row | Excel Programming | |||
highlight duplicate entries | Excel Discussion (Misc queries) | |||
How do I highlight duplicate data on a spreadsheet? | Excel Worksheet Functions | |||
highlight duplicate numbers | Excel Discussion (Misc queries) |