If Formula for several columns with text and blanks - Help

I cannot for the life of me figure out what IF (assuming that is what I need) formula to use for what I am trying to accomplish, if anyone can help, I would be so grateful!

I need to:
If in Column E a cell contains the word "Highland" then
in Column S if the corresponding cell in that row is blank,
I want it to enter text "Use Alt Form"
However, I also need to be able to overwrite the formula and enter text/date at a later time

Example:
E3 says contains Highland & S3 is blank, I need it to auto-populate to contain Use Alt Form
and have that continue through my entire worksheet for those columns

If E4 says San Marcos, I want S4 to stay blank

Hope this makes sense...

Thanks!

Hi and welcome to the forum

If I understand you correctly, you want S1 to have a formula AND to contain data?

If that is what you want, then you will not be able to do that with a regular formula A cell can contain either a formula or data, not both.

If that is not what you meant, maybe try to explain again and/or upload a sample workbook, showing what you have and what you want?

May be this......

In E2

Please Login or Register  to view this content.

and then drag down.

Glad to help you. Thanks for the feedback.
If you have got the answer, please mark your thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.