Hi Mark. I'm having trouble making this work. I created a new field called ProjectActivity that pulls together the [Project] and [Activity] fields into one (which works using the List portion of my formula). When I try to color code the new field using example 1 that you provided, it errors. I copied directly from your answer but I'm guessing I'm updating something in my formula incorrectly. Any ideas? Thanks!
List(" - ",[Project],[Activity]);
If([Activity]="Build", "<b><font color = #00cc66>" & $ProjectActivity & "</font color></b>", $ProjectActivity)
