Normally when you use a range in a formula, excel will outline with a colored border the range or cell being used so you can see the cells you're using. How come when I use the OFFSET it doesn't do that? For some reason OFFSET in Excel 2000 did it, and in 2010 it does not. Is there an add in or someway I can make it do this?


Thanks!