I have quite a large spreadsheet which is run daily to show stock levels in a traffic lights style format, the issue I'm having is that as the sheet has grown the formatting seems to be massively slowing everything down to the point where it is taking twice as long as it needs to because of the pause between moving from one cell to the next.
After doing a bit of research I can see that this is because of the volatility of the conditional formatting but I'm not sure how to get around it. Can anyone suggest an alternative to what I currently have set up? (below)
After doing a bit of research I can see that this is because of the volatility of the conditional formatting but I'm not sure how to get around it. Can anyone suggest an alternative to what I currently have set up? (below)