Public Function GetColor(ByVal status as String) as String
IF status = "Closed - Converted" Then
Return "White"
End IF
IF status = "Closed - Not Converted" Then
Return "Yellow"
End IF
IF status = "Open - Not Contacted" Then
Return "Tomato"
End IF
IF status="Working - Contacted" then
return "Red"
end if
End Function
------------------------------------------------------
select the column for display the color
=code.getcolor(Fields!color.value)
-----------------------------------------------------------
No comments:
Post a Comment