Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member183241
Active Participant

HI,

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

  1. Create Local Variable with formula “=Even(LineNumber())”.
  2. 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.



Thanks,

Kashif Ali Khan

5 Comments
Labels in this area