QUESTION REGARDING LOCKING SPREADSHEETS AND PREFORMATTED CELLS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Thank you! Your answer to my second question helped. Can you help with the
macro to automatically formulate the added rows?
 
Thanks for the feedback.

I'm sure David appreciates the kudos.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
Copy/Past from Word-spreadsheet format alignment disregarded 3
Alt codes 4
Preformatting Excel Prior to Opening Spreadsheet 1
Locking columns 3
How do you lock a cell with data but still allow new data entry? 1
Formula Question 2
Copy and pasted numbers not acting like numbers 2

Back
Top