Hi – I have a client who wants several tables built as “heat maps”. They have 20 colors, so we have 20 swatches, named 1 to 20.
The table has one number in each cell.
I need to fill each cell with the corresponding color.
I can easily format the text to “none” so it no longer appears. And, I can use Paragraph Shading and build 20 paragraph styles, all based on style 1, so that they fill the table cells and each style uses the appropriate color. Then, I can use find/change to apply the correct paragraph style to each cell based on it’s number. I can even set up multi-find-change to do all of this at once.
However – here’s why I would rather use a script – if we resize the table, the paragraph shading size will have to be changed in style 1 (others will auto update). Each table that is a different size will need a unique set of paragraph styles. There are over 20 heat maps, and while many will be the same size, it would be more accurate to know that the cell is really filled with the color, and that I’m not off by a tiny bit.
If only we could apply cell styles with find/change! That would do it.
Is anyone interested in creating a script for this? (i.e. find #1 in the text, apply color #1 to fill the cell (or apply cell style #1). I’m willing to pay, if it’s not too much.
.
