104 reputation
2
bio website
location
age
visits member for 2 years, 11 months
seen Aug 7 at 7:55

Nov
18
awarded  Supporter
Sep
11
awarded  Student
Sep
11
comment Excel: use formula in cell format
I guess that for small and simple cases that will do, but for a big and complex worksheet it may slow things down. What if the color formula references a different worksheet and not just the cell itself?
Sep
11
comment Excel: use formula in cell format
But how this VBA should be triggered? Upon every change in the worksheet? For a big worksheet this will hinder performance significantly.
Sep
11
asked Excel: use formula in cell format
Sep
11
asked Excel: use formula in cell format