Forum Discussion
MCFNeil
8 years agoQrew Captain
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>", "")
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>", "")