General discussion

  • Creator
    Topic
  • #2175448

    Locked Cells Excel

    Locked

    by gmelton ·

    I frequently use cell protection in Excel to protect formulae and values while leaving others unlocked for data entry.
    Is there an easy method of displaying the current status of cells without having to look at the FORMAT of each cell? Something like the BOLD icon in the Toolbar would be useful.

All Comments

  • Author
    Replies
    • #3322519

      Reply To: Locked Cells Excel

      by alpha48 ·

      In reply to Locked Cells Excel

      Simply use colors in the cells, either the font or the entire cell. A second distinction would be to put a border around the cell or any part thereof….

      Regards

    • #3329083

      Reply To: Locked Cells Excel

      by dryflies ·

      In reply to Locked Cells Excel

      good idea by alpha48. to expand on that you could use conditional formatting to color those cells that are locked.

      • #2468534

        Reply To: Locked Cells Excel

        by billd ·

        In reply to Reply To: Locked Cells Excel

        Good suggestion. Took me a little while to figure out the specific formulas to use with conditional formatting.
        To add formatting to all protected cells, highlight the sheet and enter:
        =cell(“protect”,a1)
        To add formatting to all non-protected cells (i.e. to show users where entries are protected):
        =not(cell(“protect”,a1))

    • #3235002

      Reply To: Locked Cells Excel

      by mike_dee ·

      In reply to Locked Cells Excel

      simple but effective method

      format one specific cell with a different pattern or font AND LOCKED.

      Then use the Format Painter Icon to copy that format to other cells that contain formulae/values.

      if you want cells to be automatically formatted whenever they contain values/formulae, you could use Format/Conditional Formatting or alternatively, VBA, for that.

      hope this helps

      mike

Viewing 2 reply threads