• Even more simple: use the expression builder and nested IIf to set the colour directly by name, e.g.:

    =IIf(Fields!Num.Value/Max(Fields!Num.Value,"DSBounds") > 0.25,IIf(Fields!Num.Value/Max(Fields!Num.Value,"DSBounds") > 0.5,"HotPink","Pink"),"White")

    Robert van den Berg

    Freelance DBA
    Author of: