1 Reply Latest reply on Jan 15, 2016 5:27 AM by disabled_JackRodgers

    Conditional Formatting Rows by Odd/Even using a category field

      I wanted to visually separate groups of rows in a portal. I had assigned a number to each item for its group and I wanted to see the groups of items using a color.

       

      I used 1,2,3... to designate the sort order by category. So I have maybe 4 rows in 1, 3 rows in 2, 6 rows in 3 and so on.

       

      I could of course assign a conditional color for each category but that could get laborious. So, I decided to just assign a color based on Odd/Even of the sortfield.. I can do this using Mod(sortfield;2) and now the even rows get the color.