Is Cond. Formatting better than Worksheet_Change?

[ElEdwards]

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!

 

[dk]

Hi,

Yes. The code should reduce your filesize.

Yes. You'll need to add to your current Worksheet_Change procedure. You can't have 2 procedures within the same scope with the same name, otherwise you'll get an 'ambiguous name' error.