Forum Discussion
Macro to "park" Conditional formatting?
Hi Peoples; I'm certainly not too adept at writing macros - but please; - would it be feasible for someone to write a marco which effectively "parked" (witheld) all Conditional Formatting from a wor...
Hi Jan - thank you for your response. I may endeavour to apply your macros but please; - which data handlikg package may you suggest; - as I am aware that Excel at times struggles to handle large data?
- I wouldn't know software that might handle this better, you just need a different take on things I expect.
I strongly suspect you won't be looking at the entire table all the time, but rather at subsets of the data. I would leave the large table alone and focus on making it easy to filter the table on another location in the workbook and applying conditional formatting to the filtered dataset.Thank you for the advice
