I am trying to create a report that has alternating colors for the rows. I can't us the record Id because the Record ID is not in sequential order when filtered (as seen below). I have been searching on how to create a new record number or something for the report itself to help do an alternating number or even/odd to use with a formula for colorizing rows, but not luck yet. Hoping someone has encountered this problem and has a fix.
Here is a sample of my report where I am trying to alternate colors. My report can change weekly so I need something that will change with the report.
| Name | Record ID# | Date | Quarter |
| Vixen | 776 | 1/21/2022 | Q1 |
| Chicken | 711 | 2/1/2022 | Q1 |
| Clothing | 709 | 3/1/2022 | Q1 |
| Dip | 721 | 3/1/2022 | Q1 |
| Mystery | 750 | 3/1/2022 | Q1 |
| Mop | 747 | 3/7/2022 | Q1 |
| Launch | 736 | 3/17/2022 | Q1 |
| Launch Chicken | 737 | 3/17/2022 | Q1 |
| Class | 710 | 3/22/2022 | Q1 |
Thanks
------------------------------
Jennifer Silberstein
------------------------------
