+ Reply to Thread
Results 1 to 2 of 2

Locking cells unless needed

  1. #1
    Forum Contributor
    Join Date
    10-30-2006
    MS-Off Ver
    O365
    Posts
    311

    Locking cells unless needed

    I want to lock cells G7 (compensation), H7 (Hire), I7 (rectification), J7 (AD), K7 (other). the bracets are the title of the column.

    In F7 i have a dropdown list with a choice of: compensation, hire, rectification, AD, other and combination.

    I want G7 (compensation) to unlock (and or change colour) if i choose compensation from my drop down in F7, H7 to unlock if i choose hire, and so on. If i choose combination in F7 i want G7,H7,I7,J7 and K7 to unlock (and or change colour).

    i hope this makes sence, and is possible. any questions let me know

  2. #2
    Forum Contributor
    Join Date
    10-30-2006
    MS-Off Ver
    O365
    Posts
    311
    Anyone got any ideas here?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1