Hi
I have a table I would like to format such that you have alternating colors by Date, so Jan-21 is say grey then Feb-21 no color, March 21 grey again, Sept 21 no color. Can someone pls advise how that can be achieved?
Date | ID | Task | Nam |
Jan-21 | xxx | xxx | xx |
Jan-21 | xxx | xxx | xx |
Jan-21 | xxx | xxx | xx |
Jan-21 | xxx | xxx | xx |
Jan-21 | xxx | xxx | xx |
Jan-21 | xxx | xxx | xx |
Jan-21 | xxx | xxx | xx |
Feb-21 | xxx | xxx | xx |
Mar-21 | xxx | xxx | xx |
Mar-21 | xxx | xxx | xx |
Mar-21 | xxx | xxx | xx |
Mar-21 | xxx | xxx | xx |
Sep-21 | xxx | xxx | xx |
Sep-21 | xxx | xxx | xx |
Many thanks,
Sylvia
Solved! Go to Solution.
Hi @SylviaK
You can use Reporting tool for that, but firstly apply Multi-Row formula for rows identification.
In reporting tool there is formula if New Field = 0 or 1 then apply background color change.
Let me know if it helps.
Karolina
Many thanks @KarolinaRoza