How do I get conditional/dynamic formatting on table calculations?

[LookerExperts]

Knowledge Drop

Last tested: Sep 27, 2018
 

If you select the "Custom" option when choosing your table calc's formatting, you can use Excel-like formatting conditions to get dynamic formatting.

Below is an example of Excel-like formatting conditions:
[<=500]0.0;[>500]0

Reference screenshots:

This content is subject to limited support.