Answer
Apply the conditional formatting rule directly on the mapped column whose displayed value you actually want colored (e.g. the 'Balance' column), not on some other mapped column used only to hold the true/false condition result. Formatting rules color the specific mapped column they're attached to — attaching the rule to an unrelated boolean/condition column won't visually color the value column you're trying to highlight.