I need to know how to write a macro or function for the following problem in Excel 2010. In Columns A & B, Rows 1 thru 19, there are entries and/or formulas. Row 20 is a sum of of rows 1 thru 19.
Is it possible through a function or macro to protect or lock columns A & B and rows 1 thru 19, if the total in row 20 is above 149.? The previous data in Rows 1 thru 19 would remain and not change or be replaced with other data.
If this is possible, how would I write the command for this. Thank you.
Bookmarks