HI
i want to implement the below logic . into existing logic .
current logic: <97 or >103 is red rest all green but now user want to see 3 colurs.
New logic :
i) <97 or >103--red
100-green
>=97 and <100 or >100 and <=103 --yellow
II) [ these ranges also need as one listbox with values red,green,blue ..so whenever user select that should show in pivot table.]
III) and one more thing is all the above ranges needs to be used as variables. because in future user wants to chnge the colur range we can only modify the variables instead of all expressions.
Note: Attached application is working fine
