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
3. At last apply Formatting Rule to Quantity and Value Column and get desire output.
Thanks,
Kashif Ali Khan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
7 | |
5 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 |