Highlight duplicates row by row (not columns)

C

ctrlrowdim

New Member
Joined
Apr 22, 2012
Messages
39
Hello, I need to highlight duplicates row by row (NOT BY COLUMNS), to compare two arrays. I trying countif and conditional formatting and avoid the absolute value, but, I have to go row by row, So, there are another function or maybe a vba code for it. here it is my tow arrays.
Code: 
 [TABLE="width: 480"]
 <colgroup><col width="64" style="width: 48pt;"> <col width="21" style="width: 16pt; mso-width-source: userset; mso-width-alt: 768;" span="6"> <col width="64" style="width: 48pt;" span="7"> <tbody>[TR]
  [TD="class: xl86, width: 64, bgcolor: #BFBFBF"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl87, width: 21, bgcolor: #BFBFBF"][FONT=Calibri][SIZE=3][COLOR=#000000]A[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl87, width: 21, bgcolor: #BFBFBF"][FONT=Calibri][SIZE=3][COLOR=#000000]B[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl87, width: 21, bgcolor: #BFBFBF"][FONT=Calibri][SIZE=3][COLOR=#000000]C[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl87, width: 21, bgcolor: #BFBFBF"][FONT=Calibri][SIZE=3][COLOR=#000000]D[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl87, width: 21, bgcolor: #BFBFBF"][FONT=Calibri][SIZE=3][COLOR=#000000]E[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl87, width: 21, bgcolor: #BFBFBF"][FONT=Calibri][SIZE=3][COLOR=#000000]F[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl87, width: 64, bgcolor: #BFBFBF"][FONT=Calibri][SIZE=3][COLOR=#000000]G[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl87, width: 64, bgcolor: #BFBFBF"][FONT=Calibri][SIZE=3][COLOR=#000000]H[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl87, width: 64, bgcolor: #BFBFBF"][FONT=Calibri][SIZE=3][COLOR=#000000]I[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl87, width: 64, bgcolor: #BFBFBF"][FONT=Calibri][SIZE=3][COLOR=#000000]J[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl87, width: 64, bgcolor: #BFBFBF"][FONT=Calibri][SIZE=3][COLOR=#000000]K[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl87, width: 64, bgcolor: #BFBFBF"][FONT=Calibri][SIZE=3][COLOR=#000000]L[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl88, width: 64, bgcolor: #BFBFBF"][FONT=Calibri][SIZE=3][COLOR=#000000]M[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl90, bgcolor: #BFBFBF, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]1[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl69, bgcolor: yellow, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]2[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]7[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl71, bgcolor: yellow, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]11[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]15[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]43[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]45[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl72, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl71, bgcolor: yellow, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]2[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]10[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]11[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]41[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]42[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl73, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]53[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl90, bgcolor: #BFBFBF, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]2[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl74, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]3[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]6[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]16[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl76, bgcolor: yellow, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]30[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]31[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]40[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl77, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]13[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]17[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]20[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]23[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]24[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl78, bgcolor: yellow, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]30[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl90, bgcolor: #BFBFBF, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]3[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl74, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]20[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]44[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]46[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]48[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]52[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]53[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl77, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]1[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]7[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]35[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]39[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]43[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl79, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]47[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl90, bgcolor: #BFBFBF, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]4[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl74, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]29[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]33[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]46[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]48[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]49[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl76, bgcolor: yellow, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]53[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl77, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]3[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]13[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]42[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]47[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]52[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl78, bgcolor: yellow, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]53[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl90, bgcolor: #BFBFBF, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]5[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl80, bgcolor: yellow, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]3[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]4[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]5[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]39[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]47[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]48[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl77, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]1[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl76, bgcolor: yellow, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]3[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]5[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]14[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]28[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl79, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]32[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl90, bgcolor: #BFBFBF, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]6[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl74, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]4[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]8[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]17[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]20[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]51[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]52[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl77, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]5[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]13[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]18[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]28[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]31[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl79, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]43[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl90, bgcolor: #BFBFBF, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]7[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl74, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]6[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]10[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]18[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]27[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]28[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]51[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl77, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]2[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]7[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]31[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]40[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]46[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl79, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]52[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl90, bgcolor: #BFBFBF, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]8[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl74, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]4[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl76, bgcolor: yellow, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]8[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]15[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]16[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]32[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]52[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl77, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]5[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl76, bgcolor: yellow, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]8[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]9[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]12[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]23[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl79, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]27[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl90, bgcolor: #BFBFBF, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]9[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl74, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]8[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]21[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]22[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]27[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]40[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]44[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl77, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]3[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]16[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]19[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]20[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]32[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl79, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]52[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl90, bgcolor: #BFBFBF, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]10[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl74, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]1[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]3[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]4[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]12[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]15[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]38[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl77, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]2[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]29[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]35[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]37[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl75, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]41[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl79, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]42[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl89, bgcolor: #BFBFBF, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]11[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl81, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]2[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl82, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]10[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl82, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]11[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl83, bgcolor: yellow, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]41[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl82, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]42[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl82, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]53[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl84, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl82, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]21[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl82, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]24[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl82, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]34[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl83, bgcolor: yellow, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]41[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl82, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]47[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl85, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2][COLOR=#000000]52[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
</tbody>[/TABLE]
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Sort by date Sort by votes
Select rows 1 to 11 or however many rows you have and use this conditional formatting formula. The row and A1 reference will automatically change for each cell.

=COUNTIF(1:1,A1)>1
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question
conditional formatting question
Replies
2
Views
205
kerm007
K
K
  • Question
Excel Pivot table Time Values is not populating same as Source Sheet
Replies
1
Views
337
awoohaw
awoohaw
imback2nite
  • Solved
VBA help.
2
Replies
10
Views
409
Peter_SSs
Peter_SSs
A
  • Question
VBA help: Removing Patient from list that has Discharged, and for non-discharged getting the time period
Replies
1
Views
68
eiloken
E
J
  • Solved
Count Values in sequence
Replies
3
Views
177
myall_blues
myall_blues

Forum statistics

Threads
1,215,777
Messages
6,126,838
Members
449,343
Latest member
DEWS2031

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top