Hello,
i have RTF template used for BI Publisher report, which its output is excel sheet.
what i want to achieve is, to highlight rows that have duplicate values with different color for each duplicates
example
employee Id | emp name
123 | osama -- Red Background
123 | osama -- Red Background
456 |Ali -- Yellow Background
456 |Ali -- Yellow Background
.
.
.
And so on..