In Google Sheets, when you use conditional formatting on a column with numeric values, is there a way to place a colored scale that is non-linear, but exponential, for example? I know you could manually format it, but that is quite a nuisance if you do that a lot.
In the below example (with German UI) there are some extreme values in the "I" column that make the scale go up very high. The average, however, is way below that and most values range from 0 to 200. Because of the extreme values, it is hard to differentiate between the smaller ones. An exponential colored scale would make much more sense here. But there doesn't seem to be an option to change the colored scale from being linear to exponential.
