Forum Discussion

JordanBeatty1's avatar
JordanBeatty1
Qrew Captain
8 years ago

Using Case function to determine the color of a field

I can't seem to get this formula working, I want if the the [Days Till Due] is greater then zero there is no change. If it is -1 or -2 then it is yellow and if it is -3 then it is red Case([Days T...
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
Just a little syntax error.  
Case([Field],
evaluation, answer is true,
evaluation, answer if true, 
answer if non-else)

Try this:

Case([Days Till Due],
-3, "<div style=\"color:black; background-color:Red;\">&[Days Till Due]&</div>",
-2, "<div style=\"background-color:Yellow;\">&[Days Till Due]&</div>",
-1, "<div style=\"background-color:Yellow;\">&[Days Till Due]&</div>", "")