I have a spreadsheet where columns A:H have 3 different long conditional formats based on values in different columns producing a different colour depending on the value.
This is making the spreadsheet very slow and i could also do with introducing a 4th colour, is there a way I could move this all to VBA and when i enter my values i simply click a button to run the macro which will fill the cells with the correct colour.
2 questions: Will this stop the spreadsheet from performing slowly and what is the type of VBA to write. Any help would be really appreciated.
This is making the spreadsheet very slow and i could also do with introducing a 4th colour, is there a way I could move this all to VBA and when i enter my values i simply click a button to run the macro which will fill the cells with the correct colour.
2 questions: Will this stop the spreadsheet from performing slowly and what is the type of VBA to write. Any help would be really appreciated.