Technology Blog Posts by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
10,858

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