I am using the following equation to change background colors:
Case (Inc Hrs < 150;GetRepetition ( gColors; 1);
Inc Hrs >151;GetRepetition ( gColors; 2);
Inc Hrs >301;GetRepetition ( gColors; 3))
1=green,2=yellow,3=red
I've run various figures in the fields to change the value that is used to calculate which repetition to get, seems to work find until it hits a value of 1000 and above, color changes to yellow. Any suggestions.