If statement and color expression

[evansabres]

I am attempting to format the background color of measure if my chart. The current expression I am using is:

=if(Max(DATE(crmDATE)) >= today(), rgb(0,255,0), rgb(255,0,0)) returning green if the date is greater than today or red if anything else. I want to introduce a third variable of returning the background of yellow if the maxdate is today -1. How can I introduce this into my equation?

[sunny_talwar · Accepted solution]

May be this

If(Max(crmDATE) >= today(), RGB(0,255,0),
If(Max(crmDATE) = Today() - 1, Yellow(), RGB(255,0,0)))