I have a spreadsheet which has 500 possible entries in one column. At present, I have each of those cells set up with Conditional Formatting (if there are more than 255 characters in the cell, make the characters red)... but I've noticed that adding more Cond. Formatting can greatly increase the filesize of my spreadsheet. (It started out at 500K and now is 3Meg)
So----
1) Would a 'Private Sub Worksheet_Change' be more efficient?
2) I already have a 'Private Sub Worksheet_Change' in place... can there be more than one instance or do I need to add to the present one?
Thanks!
So----
1) Would a 'Private Sub Worksheet_Change' be more efficient?
2) I already have a 'Private Sub Worksheet_Change' in place... can there be more than one instance or do I need to add to the present one?
Thanks!