if( ($(vCount)/$(vTotalCount))>'20%' and $(Count)>5 and Prod1Flag=1,Green(),
if( ($(vCount)/$(vTotalCount))>'20%' and $(Count)>5 and Prod1Flag=0,Red(),Grey())),Prod1Flag,Dim1,Dim2)
I am no developer, so I do not know if this is correct or not, but I believe that should account for things that do not match the first two conditions becoming grey in color. Sorry if I am missing something here, if that is the case, if you can provide further details, or even a sample app, that may help others help you...
Regards, Brett
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.