MS Excel VBA workaround for "Slow Conditional Formatting" Issue
- or -
Post a project like this2092
£20/hr(approx. $25/hr)
- Posted:
- Proposals: 13
- Remote
- #2072768
- PRE-FUNDED
- Awarded
Virtual Assistant, Excel programmer, Customer Support Agent, EN-GR/GR-EN Translator
Kornos
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
Kharkiv
IT Consultant |Virtual Assistant| graphics| | Website design | social media management .
Nairobi
137182748649564986566526671679974541111927981224690122805020989662273379
Description
Experience Level: Expert
It is documented drawback of conditional formatting in MS Excel (2016) that if you have too many formatting cells on-screen at one time, the sheet will become slow or unresponsive. We have such a sheet and we really need to solve this problem for our homecare business in the Midlands of the UK.
I believe I have exhausted all non-coded options for solving the problem through the testing I have done. I would now like someone to propose a graceful solution to the problem using more technical methods, probably VBA coding.
The sheet in question contains a lot of 6-cell boxes which we move around on a "planner". Time axis runs down the left from 0630 to 2230. The top left cell of each box works works out the planned time from the row number. The bottom right cell contains the ideal time for that call. We want the top left cell to change colour based on how far away we are from the ideal time. Screenshot example attached.
We can do this with conditional formatting but when you have 100+ boxes on-screen at the same time, dragging and dropping a single box takes 6 seconds to refresh. We need it to be quicker than this.
I believe I have exhausted all non-coded options for solving the problem through the testing I have done. I would now like someone to propose a graceful solution to the problem using more technical methods, probably VBA coding.
The sheet in question contains a lot of 6-cell boxes which we move around on a "planner". Time axis runs down the left from 0630 to 2230. The top left cell of each box works works out the planned time from the row number. The bottom right cell contains the ideal time for that call. We want the top left cell to change colour based on how far away we are from the ideal time. Screenshot example attached.
We can do this with conditional formatting but when you have 100+ boxes on-screen at the same time, dragging and dropping a single box takes 6 seconds to refresh. We need it to be quicker than this.
Andy L.
100% (4)Projects Completed
3
Freelancers worked with
2
Projects awarded
50%
Last project
1 Aug 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies