Occasional Contributor

Conditional Formatting on Columns

Hello,

Can conditional formatting be done only on Line items?

I need to apply it on Columns which are Quarters.

 

How best can I do that?

5 REPLIES 5
Highlighted
Community Boss

Re: Conditional Formatting on Columns

@hema.murali ,

 

Sadly, conditional formatting can only be done on line items, so hoping you don't have a lot of line items.  So, I used my SYS Time Filter module to determine if the period is a quarter:

 

2019-11-14_18-51-41.png

 

In my module, I have a conditional formatting line item with the following formula: IF SYS Time Filter.Quarters Only THEN 1 ELSE 0 with the summary with Formula

 

2019-11-14_18-55-28.png

 

Created 3 different conditional formatting rules, all based on my line item Cond Format

 

2019-11-14_18-56-25.png2019-11-14_18-56-48.png2019-11-14_18-57-00.png

For a final look of:

2019-11-14_18-57-50.png

 

Hope this helps,

 

Rob

Community Boss

Re: Conditional Formatting on Columns

Vote for this idea to help with the efficiency

using a different line item to format multiple line items

https://community.anaplan.com/t5/Idea-Exchange/Conditional-Format-using-line-items-from-another-modu...

 

David

Occasional Contributor

Re: Conditional Formatting on Columns

David,
Done!

thanks
Hema
Occasional Contributor

Re: Conditional Formatting on Columns

Rob,
Will work this & see

thanks
Hema
Community Boss

Re: Conditional Formatting on Columns

@DavidSmith thanks for highlighting the idea! Voted for!