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?
@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
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
@DavidSmith thanks for highlighting the idea! Voted for!
Can anyone please explain how to update my registered email ID jn Anaplan.
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…
