Hi, i want to highlight first 3 rows in 'Yellow' colour & next 3 rows in "Green" colour & next three rows in "red" colour......Can anyone guide me?
Select the column(s) that you want to highlight:
- Click Conditional Styles
- Create an advanced conditional style
- Use "RowNumber () < 4" to target the first three rows
- Create the Style
- Repeat for "RowNumber () < 7" and "RowNumber () < 10"
Thanks for your Help. My report contains 1000 rows.......
Do you mean that you want the following?
- Rows 1 to 3: yellow
- Rows 4 to 6: green
- Rows 7 to 9: red
- Rows 10 to 12: yellow
- etc.
You can achieve that by creating a second object with the expression: mod(running-count([Your Object]);9)
Change the advanced conditional style to:
[second object] between 1 and 3: yellow color
[second object] between 4 and 6: green color
other values: red color
Yes this is the one I need for my requirement. Thanks for your valuable help....