How to apply colors in single and Multiple values

[vinod2086]

Hi All,

I have a requirement. in my source file i have diff columns like below

SITE LIMIT 1 CONDITION

SITE LIMIT 1 VALUE

AGGR LIMIT 1 CONDITION

AGGR LIMIT 1 VALUE

here i have concatenated site and Agg value and condition

"SITE LIMIT 1 CONDITION" & "SITE LIMIT 1 VALUE" as Site_Red,

"AGGR LIMIT 1 CONDITION" & "AGGR LIMIT 1 VALUE" as Agg_Red,

but my actual req is i have below data

ID	Code	SITE LIMIT 1 CONDITION	SITE LIMIT 1 VALUE	AGGR LIMIT 1 CONDITION	AGGR LIMIT 1 VALUE
5013	W1	>	0	>	0
5009	W2	>	50	<	0.8
5016	W3	>	10	<	0.8
5015	W4	>	95	<	0.8
5013	W1	<	10	>	5
5013	W1	>=	10	>	15
5009	W2	>	0	<	0.8

here i want to display Color based on ID here i want to display color as Red for Site_Red  & Agg_Red columns.

if it is single value it should display site_red if is multiple values it should display Agg_red based on ID.

Pls help on this

stalwar1‌

reddys310‌

Thnaks in Advance.