Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Is there a way to filter and do conditional formatting for odd/even numbers used from auto-number?
If not, I would like to pose this as an enhancement request.
You can add another colum with the formula
=IF(INT([Row ID]1 / 2) = [Row ID]1 / 2, 0, 1)
assuming that [Row ID] is your auto-number. If the row id is odd then you'll get 1 and 0 if even.
You can then filter/do conditionnal formatting based on this column (see column 3 in the screenshot below).
Hope this helps.
Thank you! That formula works. But, it doesn't work on auto-number with prefix.
Fixed length prefix?
Check out the RIGHT() function.
Craig
Your auto-number column could be number only and another column can contain the whole string (prefix + auto-number)
These methods only work if you do not insert or move rows. The row ID's are static and odd id numbers can be adjacent, negating the effect. A real WBS numbering system is needed to make this work. Or an ability to reference an item's actual row number.
+1 for reference to actual row number
+1 too
I've got your votes for this logged to our enhancement request list!
