+ Reply to Thread
Results 1 to 2 of 2

change locked cell color

  1. #1
    Registered User
    Join Date
    01-22-2019
    Location
    Breda
    MS-Off Ver
    365
    Posts
    10

    change locked cell color

    Hi,

    Do you know how I can lock a cell but still allow people to change values as well as the color, without allowing people to change color in other cells?

    Thank you!

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,947

    Re: change locked cell color

    Unlock that one cell but lock the others, and protect the sheet. Locking a cell prevents changes to that cell when the sheet is protected - which is the opposite of what you seem to want....
    Bernie Deitrick
    Excel MVP 2000-2010

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Color changing: change the color of one cell, and have other cells change colors too
    By hadydea in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-17-2019, 04:51 PM
  2. Change cell format (cell color+font color) based on color of another cell
    By Dedaluss in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2017, 03:27 AM
  3. Macro to change cell text color based on darkness of cell fill color
    By cincyshirm61 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2014, 12:11 PM
  4. Replies: 2
    Last Post: 03-07-2012, 09:42 AM
  5. Change cell colour when the protection is locked
    By codepin in forum Excel General
    Replies: 4
    Last Post: 12-27-2010, 06:39 PM
  6. Format cell color on change, how to change the color in other columns as well?
    By s80NL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-28-2007, 09:24 PM
  7. Color Cell Based on Locked/Unlocked Property
    By sowetoddid in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-02-2005, 05:21 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1