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

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