I want to create conditional formatting color on text table data view. Can you help anyone regarding this question.
condition is below:
1. <=1000 is value color should be black.
2. >1000 and <=3000 colour should be green
3. > 3000 color should be red
Write a calculated field as you described it, and put it on the color shelf--with a simple setup like yours, you can do this pretty easily.
if [FieldName] <= 1000 then "Black"
elseif [FieldName] > 1000 AND [FieldName] <= 3000 then "Green"
You may need to use sum([FieldName]), but hopefully you get the idea.