Ask Your Question

Can Color Scale formatting be logarithmic?

asked 2020-07-12 12:05:58 +0200

jondo gravatar image

updated 2020-07-12 12:06:17 +0200

For a data table, I want to get conditional formatiing with a (two entry) color scale, such that the colors are not distributed linearly, but logarithmically (i.e. the data table should be coloured as if it contained the logarithms of the original values). This is useful when the entries span a great numeric range, but you still want to see the differences of small values, too.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-07-12 12:11:18 +0200


Of course you can use 3-entries color scale, and put the medium color closer to your small values. If that doesn't fit you, you may need to add a column with logarithms of your data, and color-scale format it.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-07-12 12:05:58 +0200

Seen: 48 times

Last updated: Jul 12