Optimize table row coloring

[GregFreeman]

I think there have been some threads on this, and there may not be a good solution. I'm coloring alarm rows red in a table. The image below shows how I'm trying to optimize it now. Defer panel updates doesn't help a whole lot. Is there anything else I can do, or am I pretty much stuck?

[tst]

First, deferring is certainly recommended.

Second. It helps to read the help. If you look at the help for the ActiveCell property it will point you to the very useful -1 and -2 values, which select the headers and the entire row/col, respectively. In your case you can use a [-2,-2] to reset all and then a [i, -2] for your row.

[GregFreeman]

---

@tst wrote:

First, deferring is certainly recommended.

Second. It helps to read the help. If you look at the help for the ActiveCell property it will point you to the very useful -1 and -2 values, which select the headers and the entire row/col, respectively. In your case you can use a [-2,-2] to reset all and then a [i, -2] for your row.

---

I definitely will use defer, I just didn't put it in this example. Thanks for the hint!