i am trying to add background color to table, i am updating XML at runtime.
what i have achived is with following code is i am able to color first 3 rows
<BackgroundColor>=iif(RowNumber(Nothing)> " + cout + ", \"#fff7a9\", \"#baecc4\")</BackgroundColor>
i need to color last 4 rows also how can i do in same command?
What I have tried:
i have tried following code but it did not work
<BackgroundColor>=iif(RowNumber(Nothing)>= " + cout + ", \"#fff7a9\",iif(RowNumber(Nothing)>= " + dt2count + ", \"#baecc4\") </BackgroundColor>
<BackgroundColor>=iif((RowNumber(Nothing)>= " + cout + ", \"#baecc4\", \"#fff7a9\" AndAlso RowNumber(Nothing)> " + dt2count + ", \"#baecc4\", \"#fff7a9\"))</BackgroundColor>
in the above code,"cout" gives count of first three rows and "dt2count" gives count of last 4 rows.