JenniferSilbers
3 years agoQrew Trainee
Trying to alternate row colors based on creating a new row number
Hello,
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.
Thanks
------------------------------
Jennifer Silberstein
------------------------------
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
------------------------------