Change the duplicate values color in a field

[Sri4]

I have 5 rows of data and all are same value . I have scenario first row value should be black color and rest of 4 values are in same color

[udit_k]

use below expression in background color script of expression :-

=if(rowno()<=1,Red(),Green())

[Sri4]

My Scenario is 

load * inline [

name

abc,

abc,

abc,

xyz,

xyz   ];

I wanna to display one duplicate values to be red color and first row data is black color

[udit_k]

ok, use aggr function to customize  requirement:-

for example:-

if(sum(aggr(count(USER),Region))>1,Red(),if(rowno(TOTAL)=1,Black()))