Set a color in conditional format by formula

@Johg_Ananda , I have run a simple test.

I created a table with 1000 rows, each with a single Image(Format(SVG,…)) with random colors .
I triggered the execution of just the 1000 Image(Format(Svg, …)) functions and the refresh was a small fraction of a second. So short I couldnt clock it on my stopwatch.

Not the most scientific test, but more than enough to stop me worrying about the performance hit from SVG.
Its way faster than loading 1000 small images, which was what I was doing before.

No doubt, scaling this to tens of thousands or rows might be problematic, but my clients dont display that much data on their dashboards due to the use of filters etc.

So I am happy to use SVG colored text for now, until Coda releases a proper function for setting the background color for text.

HOWEVER: take a look at my post on using the OFFICIALLY SUPPORTED conditional format COLOR RANGE feature to set background colors (from a limited palette) AUTOMATICALLY - it meets most of my needs.

Respect
Max Xyzor

5 Likes