table color does not reset

[murchak]

My table (AVG SUM TABLE) is supposed to show entries less than zero in red. It has a small problem. The first time it works, but the second time the text color does not go back to black when I run it again.

It remembers the entries that were red from before. Based on my wiring below, the second time I run it, it should set the background color to light yellow, and the text to black, then perform the for loops.

BTW, I also used a flat sequence to force this order, but that didn't help.

[GerdW · Accepted solution]

Hi murchak,

from what can be seen in your picture you

- only set one cell to "light yellow" background: ActiveCell=(2; 2)

- then you set the first 3 rows to background "light green"

- then you set some cells, depending on their value, to red. (Btw. there's a special "<0" function in the comparison palette!)

There's no place where you set a black background for all cells!

Maybe you should try ActiveCell (-2; -2) instead?

[murchak]

Thank you GerdW.

-2,-2 did the trick. that's what happens when coding is done at 2 AM. can't believe I didn't see that.