Hello, I have a report that has a grouping and the amount is a sum of Amount totals based on this group. What i will like to do is check within the same column if an entry already exist and highlight it in bold or colour.
Example:
I am grouping by example Stock Name:
Stockname: Amazon Shares[
Order Ref | Amount
123 | 240
345 | 345
678 | 2,898
789 | 745
978 | 240
998 | 120
999 | 63
What i will like to do is highlight 240 as this is showing twice. Note this is not a duplicate as the Refs are different. I just want to either colour or highlight this because this number already exist in the column as rows 1 and 5. This is a sum(Amounts) and are not displayed in the details section but rather at the group level.
Is there a way to do this?
Thanks
Example:
I am grouping by example Stock Name:
Stockname: Amazon Shares[
Order Ref | Amount
123 | 240
345 | 345
678 | 2,898
789 | 745
978 | 240
998 | 120
999 | 63
What i will like to do is highlight 240 as this is showing twice. Note this is not a duplicate as the Refs are different. I just want to either colour or highlight this because this number already exist in the column as rows 1 and 5. This is a sum(Amounts) and are not displayed in the details section but rather at the group level.
Is there a way to do this?
Thanks