If anyone is interested I found a code that works for me.
Old (checkbox version):
If([Scheduled - Yes]=true,$green,
If([Scheduled - Yes]=false and [Appointment Needed By] >= Today(),$yellow,
If([Scheduled - Yes]=false and [Appointment Needed By] < Today(),$red)))
New (multi choice version):
If([Scheduled - Yes]="Scheduled", $green,
If(([Scheduled - Yes]="Missed"), $gray,
If(Contains([Scheduled - Yes],"Unscheduled") and [Appointment Needed By] >= Today(),$yellow,
If(Contains([Scheduled - Yes],"Unscheduled") and [Appointment Needed By] < Today(),$red))))
Thanks!
