nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Conditional Formatting on Columns

hema.murali

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?

Accepted answers

All comments

rob_marshall

@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:

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

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

For a final look of:

Hope this helps,

Rob

DavidSmith

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-module/idi-p/44191

David

hema.murali

David,
Done!

thanks
Hema

hema.murali

Rob,
Will work this & see

thanks
Hema

usman.zia

@DavidSmith thanks for highlighting the idea! Voted for!

Quick Links

Can you help?

Unanswered questions

How can I use the RANK function with composite hierarchies where parent items can't be concatenated?
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…