Cloud Stack Ninja

My spreadsheet has a column of numbers (big surprise, huh?) of which certain ones must be highlighted. This choice depends on numbers in other columns in a non-simple way, so I have a macro that goes up the list, determines whether each cell should be highlighted or un-highlighted, sets the cell as such, and loops to the next one.

This process is too slow for me. Even using Application.ScreenUpdating = False, and skipping cells that are already the right color, the macro takes about 10 seconds to run.

If I were changing the contents of the cells, instead of their color, I would pull the whole column into an array, run the macro on it, and paste the results back. You all know how fast that is.

But is there an equivalent method for quickly setting the highlight color of the whole column?

Read more here:

Content Attribution

This content was originally published by Shawn V. Wilson at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: