New to Qlik Sense

[MikeF]

I have this expression that I pulled from another post and it is working in my app now.  How do you add color to this expression when the count >1.   Thanks/Mike

=aggr(
only({<[Estimate number]=>}[Estimate number])
& repeat(chr(160),16)
&num(
count({<[Estimate number]=>}DISTINCT [Job ID])
,'#,##0')
,[Estimate number])

[Rockstar7]

@MikeF 

you can write text color expression using second expression in your logic

count({<[Estimate number]=>}DISTINCT [Job ID])

Like this:

if((count({<[Estimate number]=>}DISTINCT [Job ID]))>1,green(),red())

[MikeF · Accepted solution]

Thanks that worked perfectly!