User-10017267 posted
This has been my only solution so far
= iif(instr(first(Fields!CompletedDateTime.Value) ,"M") > 0 , "PowderBlue",
iif(first(Fields!CompletedDateTime.Value) = "1","Yellow",
iif(first(Fields!CompletedDateTime.Value) = "2","Yellow",
iif(first(Fields!CompletedDateTime.Value) = "3","Yellow",
iif(first(Fields!CompletedDateTime.Value) = "4","Yellow",
iif(first(Fields!CompletedDateTime.Value) = "5","Yellow",
iif(first(Fields!CompletedDateTime.Value) = "6","Yellow",
iif(first(Fields!CompletedDateTime.Value) = "7","Yellow",
iif(first(Fields!CompletedDateTime.Value) = "8","Yellow",
iif(first(Fields!CompletedDateTime.Value) = "9","Yellow",
iif(first(Fields!CompletedDateTime.Value) = "10","Yellow",
iif(first(Fields!CompletedDateTime.Value) = "11","Yellow",
iif(first(Fields!CompletedDateTime.Value) = "12","Yellow",
iif(first(Fields!CompletedDateTime.Value) = "13","Yellow",
iif(first(Fields!CompletedDateTime.Value) = "14","Yellow",
iif(instr(first(Fields!CompletedDateTime.Value) ,"-") > 0 , "Red","Green"))))))))))))))));