How to enable alternate row coloring in BO 4.2 as Green with background color as Grey

[former_member399387]

Hi Team

How to enable alternate row coloring as Green with background color as Grey?

I have tried the same through option Format table -> appearance->frequency set -2, color : Green.But it is working only when background color is set to Default.

I have tried it through creating variable and applying alert to each column of report. It is working but it is time-consuming.

Thanks

Shilpi

[Former Member]

Hi Shilpa,

Create a Dimension with formula as LineNumber(). Now drag this to your table and hide this dimension. Now on the Analysis tab you can see Conditional Formatting option you can set the desired formatting based on the odd or even line number.