+ Reply to Thread
Results 1 to 3 of 3

Highlighting Locked/Unlocked Cells

  1. #1
    Registered User
    Join Date
    10-04-2010
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Highlighting Locked/Unlocked Cells

    The post below came from ChemistB back in 2008. I tried to make it work in Excel 2007 to no avail. I am guessing the instruction assumes that the reader is more experienced than I am.

    Any help would be appreciated.

    Thanks,

    1. Go to Define names and select a name (e.g. LockedCells).
    2. Refers to: =Get.Cell(14,INDIRECT("rc",FALSE)). Add and OK.
    14 is the code for returning true or false to whether a cell is
    locked or not.
    3. Select range (or whole sheet)
    4. Conditional Formatting Formula is =NOT(LockedCells)
    Select a nice colorful format and OK

    All unlocked cells will be formatted as per your conditional format.

    Note, this overwrites any previous Conditional formatting so you wouldn't want to overwrite your file after performing this exercise.

    ChemistB
    Last edited by jderren; 10-04-2010 at 03:39 PM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,279

    Re: Highlighting Locked/Unlocked Cells

    Wow, was I around in 2008?!

    The GET.CELL is a Excel 4 macro so you must have macros enabled and (if saving) save as xls or xlsm file.

    Attached is an example where I followed the above directions exactly. You can lock or unlock any cells in the worksheet and they will turn green (if unlocked). Does that help?
    Attached Files Attached Files
    Last edited by ChemistB; 10-04-2010 at 03:48 PM.
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    10-04-2010
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Highlighting Locked/Unlocked Cells

    Works like a charm!!! Thanks!!!

+ 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