Automatic Converting of Cells Into Range Notation and Conditional Formatting

[ajarmstron]

Hi - I am generating lists of cells that are being conditionally formatted e.g. A1, A2, A3, B1, B2 and B3. However, these cells can often be shortened e.g. A1:B3. Will the spreadsheets work quicker if they are given data that is specified as a range?

If so, is there a way of processing lists of cells (such as my A1, A2, A3, B1, B2 and B3) so they are automatically converted into range notation? (Does this exist?!)

Thank you for any comments!

 

[Joe4]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Automatic Converting of Cells Into Range Notation and Conditional Formatting
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.