QUESTION REGARDING LOCKING SPREADSHEETS AND PREFORMATTED CELLS

T

TLAngelo

I have a spreadsheet in which I have locked the columns that contain formulas
so that people who input data to the spreadsheet will not inadvertently type
over the formulas. The problem I am running into is that when someone
inserts a new row, the formulas need to carry into the inserted row, is there
a way to do that?

My other question is:

In my spreadsheet, I have preformatted one column to put "Yes" if the
processing times of 3 identified cells is less than or equal to .75. The
only problem is that it puts "Yes" in the cells that do not have any data
input into them yet. Is there a way to have it display "TBD" until someone
enters data into that row?
 
S

SimonCC

For question 1, I don't think there's a way to do so easily unless macros is
involved.

For question 2, try:
=IF(OR(A1="",B1="",C1=""),"TBD",IF(SUM(A1:C1)<=.75,"Yes","No"))

-Simon
 
T

TLAngelo

Thank you! Your answer to my second question helped. Can you help with the
macro to automatically formulate the added rows?
 
G

Gord Dibben

Thanks for the feedback.

I'm sure David appreciates the kudos.


Gord Dibben MS Excel MVP
 
Top