Color Coded Calendar Report Formula

Question

I have the calendar report with a color coded formula so that if the field "Salesperson" is the user it is one color, and if not user it is a different color.
Case([Salesperson], User(), "#F0cd95", "#eddd85")

I'd like to add a third option/color, if the Salesperson is "Not the User but Not Blank". This seems like it should be simple, however I'm drawing a complete blank about how to write this.

So, I'd like:
User = Color 1
Not User = Color 2
Blank = Color 3

Any help would be appreciated.
Thanks

------------------------------
Brianne Jacobsen
------------------------------

markshnier__you · Answer

I think we will use an IFIF(IsNull([Salesperson]), "#color 3 hexcode",[Salesperson]=User(), "#F0cd95", "#eddd85")​------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

briannejacobsen · Answer

Thank you!&nbsp; I knew it should be simple but it is Friday; my brain is mush :)------------------------------Brianne Jacobsen------------------------------

Forum Discussion

Color Coded Calendar Report Formula