Results 1 to 4 of 4

Thread: How to lock specific row if a certain value exists in one cell?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 12-01-2012, 11:44 PM #1
    Rajesh Kr Joshi
    Rajesh Kr Joshi is offline
    Member
    Join Date
    Aug 2011
    Posts
    92
    Rep Power
    14

    How to lock specific row if a certain value exists in one cell?

    Hi,

    How do I lock a row, if in column C a certain value exists?
    In the attached sheet I have a daily employee attendance sheet, if an employee left or resigned the same is shown in column C using a formula. Is there a way to lock the specific row if it has a value Left or Resigned?



    Thank
    Rajesh
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Delte a specific column and does not delete the top row
    By jffryjsphbyn in forum Excel Help
    Replies: 1
    Last Post: 06-13-2013, 02:00 PM
  2. How To Lock Or Protect Cell Using Data Validation
    By mahmoud-lee in forum Excel Help
    Replies: 4
    Last Post: 06-06-2013, 01:57 AM
  3. Highlight Active Cell’s Row and Column
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-17-2013, 12:32 AM
  4. Lookup From Cell Range By Matching Row and Column
    By paul_pearson in forum Excel Help
    Replies: 2
    Last Post: 03-07-2013, 02:02 PM
  5. How to Lock or Unlock row basis previous cell input?
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 2
    Last Post: 07-25-2012, 02:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules