Conditional Formatting by time

Is there a way to format conditionally according to time? The simplest example is that I want my actual time periods to be one shade and my future/forecast periods to be another shade, for all line items. It looks like the conditional formatting is all based on individual line item values.

Accepted answers

PrevContributor

Hey Jeff,
You might be able to do this by creating another line item that evaluates if it is an actual month and then use that line item to base the conditional formatting off of...but you would have to create a rule for each line item if you have several line items. See the attached pictures for more details.

Let me know if this helps. Thanks!

Jill King

All comments

PrevContributor

You are able to format line items based on a date in the way you describe by doing the following. In your module, you need to add two new line item one called Date that is date formatted and pulls the date property from your part number list.
The other new line item will be numeric and should have a formula of IF Date > END() THEN 0 ELSE 1. Call that one Date Test. Next you will put in Conditional formatting using the new icon on the toolbar. Put in a new rule, choose the line item you want to format, choose Based on the Values From Date Test, choose a two color scale, choose minimum 0, maximum 1, then from your color choices pick the one with red on the left and white on the right. Choose OK and this should get you the formatting that you are looking for.

Quick Links

Can you help?

Unanswered questions

ANAPLAN XL View
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.
Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…