Of course, this can also be done in LL20, but it requires some knowledge of properties and formulas. You need to find the font color property, figure out how to use a formula for it and use a Cond() function that does the handling. If you want to add more conditions (e.g. bold font for one threshold and a highlight color for another), you quickly end up with a nested Cond() statement that can get quite complicated. The average end user will probably not be able to handle this gracefully.
Enter the brand new Conditional Formatting feature. This is a great way to combine easily accessible formatting rules in one place. You can enter cascades of conditions and you can even tell LL21 if a rule should stop further processing once it matches or if other rules should be processed additionally. For each value type there are loads of handy presets that make defining conditional formattings a piece of cake.
Let’s do a quick walkthrough – imagine a customer list where you want to color-code the customers depending on their revenue share. You want different colors for shares below 0.2% (reddish) and those above 1%, 2%, and 3% (different greens). If you don’t have the revenue share in your database, it could e.g. be calculated using the native aggregate functions I’ve blogged about before.
The table column now has a new property “Conditional Formatting”:
Leading the development at combit as Managing Director. Microsoft .NET enthusiast driving innovation & agile project management. Used to be a physicist in my first life. I love hiking and vanlife.
