I used a macro like :
Sub test()
If ActiveCell.Value = "" Then
With Selection.EntireRow.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = xlAutomatic
End With
End If
End Sub
to mark the identical rows in after exporting the table to excel. Can a similar one be used on the access table ?
No I have already done that, what i need to do is if there are certain fields that are common in the rows they should be highlighted or maybe change the font to bold.
Eg:
Name school city
Joe ABC XYZ
Joe ABC PQR
Mark MNO CCC
So I am able to get the output :
Name school city
Joe ABC XYZ
Joe ABC PQR
Which selects the rows with the identical name. Now i want to highlight the school ABC as thats the same in both rows. If thats not possible can I change the font to bold. As i was able to do this in excel using code but could not manage to do this in access.