+ Reply to Thread
Results 1 to 7 of 7

Conditional Formatting to Lock a Cell

Hybrid View

  1. #1
    Registered User
    Join Date
    12-19-2008
    Location
    CA
    Posts
    64

    Re: Conditional Formatting to Lock a Cell

    Squiggler,

    I am locking the sheet and they will only have a limited group of cells in which they can enter information... but SOMETIMES, they have to enter data in Column C but only if someone else did not enter information in Column B.

    I don't want them to enter in information into Column C if Column B already has information in it... and they will, even if they are told not to, unless I lock them out of it.

    VBA seems the best option here... and I'm halfway to a solution in that arena.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Conditional Formatting to Lock a Cell

    I don't like the VBA store. It's like the IRS trying to sell you a used car ...
    You sent me into a chuckling fit -- thank you
    VBA seems the best option here... and I'm halfway to a solution in that arena.
    Show us what you end up with. We'll see if we can add a free air conditioner ...
    Entia non sunt multiplicanda sine necessitate

+ 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