What would be the best approach to select cell style based on cell value in the whole Table versus in a single column?
Let’s say, I have a table that contains cells with random numbers from 1 to 10 in each cell. I want all numbers lower than 3, to be green, 4-7 yellow, and 8+ to be black.
For what I’ve read, I need to pull all column names and iterate by each column to apply colors. That may work for smaller tables but I afraid that this method can be a bottleneck if Table grows in size.
I’m reading docs and studying examples but cant find a good solution.
Any suggestions, pls?