As per requirement we need to show alternate color in cross table rows as per below screen shot.
We can do the same by below solutions.
Solution 1: With Inbuilt option
Step 1: Write Click on Table, select Format Table then Appearance.
Step 2: In Alternate Color Option, set Frequency and Color as per requirement.
Solution 2: By Creating Conditional Formatting Rule
- Create Local Variable with formula “=Even(LineNumber())”.
- Create “Conditional Formatting Rule” on Local Variable refer below screen shot.
3. At last apply Formatting Rule to Quantity and Value Column and get desire output.
Kashif Ali Khan