I have another field in the cursor that I need to add into the mix. It's to a more detailed level and I want to be able to darken the colors for those rows based on the other field value. In the code below, I'm using light blue, light green and light red. If the SUBSCRIBER records have a value in the other field, then I want to have them be alittle darker. Do I have to keep nesting stuff like that into this one expression, or is there another way to handle that?
TEXT TO lcDynBackColor NOSHOW PRETEXT 15
ICASE(UPPER(ALLTRIM(WorkListXMLCursor.GroupHeading)) == [RECEIVER] , RGB(192, 241, 190),
INLIST(UPPER(ALLTRIM(WorkListXMLCursor.GroupHeading)), [SUBSCRIBER], [DEPENDENT]), RGB(211, 210, 240),
RGB(249, 223, 223))
ENDTEXT