View the original community article here
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.