Conditional Formatting Rows by Odd/Even using a category field

Discussion created by disabled_JackRodgers on Jan 15, 2016
Latest reply on Jan 15, 2016 by disabled_JackRodgers

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.