Skip to main content
V
Vigneshwar
Newcomer
May 31, 2023

Alternate column different background color

  • May 31, 2023
  • 1 reply
  • 0 views

Is there a way to display alternate columns in different colors even if we apply expansion (e.g.   .tree , .children etc.)

1 reply

H
HoneyGulati
Newcomer
May 31, 2023

Do you mean rows or columns?

We can achieve it through conditional formatting in Cube views

. 

 

V
VigneshwarAuthor
Newcomer
May 31, 2023

It is for Columns 

Can you give some sample codes to achieve alternate colors to the column when we use expansion

H
HoneyGulati
Newcomer
May 31, 2023

The conditional formatting can be done based on various factors such as indent level  , member description , header display text etc

For Ex: I used 2024.base in my columns which will populate all the months of 2024 and then used header display text to add colors to alternate months

Formatting

If (ColE2HeaderDisplayText Contains 'Apr') OR (ColE2HeaderDisplayText Contains 'Jun') OR (ColE2HeaderDisplayText Contains 'Aug') OR (ColE2HeaderDisplayText Contains 'Oct') OR (ColE2HeaderDisplayText Contains 'Dec') OR (ColE2HeaderDisplayText Contains 'Feb') Then

BackgroundColor = Linen
Else

BackgroundColor = SkyBlue
End if

HoneyGulati_0-1685530507200.png

 

    Terms & ConditionsAccessibility statement