COLOR CODEING NUMBER

[#1]

How do you do a color code like below I know how to use?

The numbers are averaged for wait times

Color code in brackets 1 - 5 red 6-8 green 9 and over yellow

[sunny_talwar]

Remove this extra parenthesis:

Similarly remove the second parenthesis on the second row also. You don't want to end your if statement after the color.....

[#3]

I did that and still errors

both lines work but just not together.

[sunny_talwar]

So this isn't working?

If(Avg(ActualLeaveTime-ScheduledLeaveTime) < MakeTime(0,30), RGB(231,248,31),

If(Avg(ActualLeaveTime-ScheduledLeaveTime) < MakeTime(1), RGB(255, 0, 0)))

[#5]

I have not had time to test this one but wanted to let you know that

I appreciate your help