Apply Conditional Formatting only to Totals in a worksheet

ENetchev
New Contributor

Apply Conditional Formatting only to Totals in a worksheet

Hi Anaplan community, 

 

I have run into the following conundrum - I want to apply conditional formatting only to the totals of my line items in a worksheet. Now, I know that this isn't possible out of the box as Anaplan applies conditional formatting on a line item basis; however, I checked out this workaround posted by @ChrisHeathcote

 https://community.anaplan.com/t5/Anaplan-Platform/Highlighting-Parent-Rows-of-a-List/m-p/86006#M190...

 

The problem I have with this workaround is that it applies strictly to lists (and their parents/children), but the data of my line items is a sum formula. To give a bit of background, it's a PM dashboard that where Jira tickets have different estimates are spread across various sprints. So the formula I have for the data of the line item in question is: 'SYS02 Ticket Details'.Remaining Estimate[SUM: 'SYS02 Ticket Details'.Planned for] where planned for denotes the sprint the estimate of a ticket is in. 

 

Here is a view of my worksheet. Is there a possible workaround? Perhaps I'm misunderstanding something from the abovementioned article, but I'm not so sure I am. 

 

Thanks for the help, 

Emil

1 REPLY 1
ChrisHeathcote
Community Boss

Re: Apply Conditional Formatting only to Totals in a worksheet

@ENetchev 

Create a dedicated conditional formatting line item which queries the SUM line and outputs a number variable which can be used to create the input for the conditional formatting. Therefore, you will be able to set the summary method for this new line item to Formula.

 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA