Frequent Contributor

Conditional formatting: Border style

styles.pngborder.png

  • Conditional formatting is a great way to communicate the meaning of your values to your end users, but it isn't always easy to read the cell text when the background has a color applied.
  • We've added Border, a new Style option for when you configure your rules in your custom view.
  • When you apply the Border style, your conditional formatting colors are still applied to the cells, but the text displays on a much paler background. This makes it easier to read the cell values.
  • This style gives you extra flexibility if you or any of your users require a higher level of visual contrast.

Conditional formatting: Morse style

morse.png

  • In addition to Border, we've added a third Style option called Morse.
  • Morse differs from traditional conditional formatting. It doesn't change the background color of the cell; instead, it displays an in-cell element to indicate the cell value compared with your conditional formatting rules.
    • Cells that match, or are lower than, your minimum rule value display as a small dot.
    • Cells that match, or are greater than, your maximum rule value display as a long dash.
    • Cell values that fall between the minimum and maximum will scale proportionally, based on the value's location in the overall scale.
    • Each element also takes on the color that would normally be applied by the conditional formatting.
  • Not only is Morse great for providing an accessible, readable alternative to conditional formatting, but the scaling of the elements makes it easier to see trends and detect anomalies.

Home: Models page

all-models.png

  • You can now use the new Home experience to browse all of the models you have access to.
  • To access the models list, use either the Models link (in the blue header bar, top-right) or the View all models link, or click the Models title on the Home page.
  • When browsing your model list, you can sort (by clicking the list headings) and filter, as well as search for the model you'd like to open.
  • To switch back to the original models list, just select Models from the main navigation menu.

We value your input! To leave feedback at any time, click Feedback in the navigation bar, then select Feedback.

12 Comments
Master Anaplanner/Community Boss

Liking those formatting options for conditional formatting!

Community Boss

Love the new Morse styling! Will this be available in old UX at any point?

Frequent Contributor

Thanks @andrewtye - we're particularly proud of those ones 🙂

 

Sorry @CallumW - these are only going to be available in the New UX.

Community Boss

No problem, thanks for the quick reply @davewaller !

Certified Master Anaplanner

The conditional formatting enhancements are brilliant, and love the Morse styling.

 

And the improvement to the Models view is really good - the 'at a glance'/filter view of Model states is really valuable for admin/ALM (and good to see the Model Mode icon tooltip has been fixed too).

Certified Master Anaplanner Certified Master Anaplanner
Certified Master Anaplanner
Hi, The conditional formatting looks very good! Is there a plan to enable the use of this formating on saved view? I almost exclusively use saved views, it's easier so far to build and keep views organized in the model. It would be useful to apply the formating saved views as opposed to custom views only.
Frequent Contributor

Hi @Ari - no plans to provide these new features against saved module views although we are exploring ways we can make things easier for builders to capitalize on the content they have already in their models. It's a difficult problem to solve but we're starting the thought process.

Contributor

These Improvements are great and give an interesting view to the look and feel.

Specifically Morse style.

Occasional Contributor

Both features are very good. I agree with suggestion of providing the conditional formatting for saved views. It would be definitely great to have it there.

New Contributor

Excellent ! The new conditional formatting styles will definitely bring more value by making impactful boards.

Do you know if we will be able (feature planned soon?) to choose existing line items for the color range settings ?

Certified Master Anaplanner

Great one with Morse!

Can we expect some arrows in the future?

Certified Master Anaplanner

Nice enhancement, I love the morse too! Are you planning/exploring the possibility of introducing data bars and Icon sets ? 

 

Thanks,

Alessio