TechRepublic|Forums|Software

Software

General discussion

  • Creator
    Topic
  • March 16, 2005 at 4:05 pm #2175448

    Locked Cells Excel

    Locked

    by gmelton · about 17 years, 2 months ago

    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.

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • March 19, 2005 at 8:50 pm #3322519

      Reply To: Locked Cells Excel

      by alpha48 · about 17 years, 2 months ago

      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

    • March 21, 2005 at 12:21 pm #3329083

      Reply To: Locked Cells Excel

      by dryflies · about 17 years, 2 months ago

      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.

      • October 29, 2007 at 1:46 pm #2468534

        Reply To: Locked Cells Excel

        by billd · about 14 years, 7 months ago

        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))

    • March 31, 2005 at 8:56 am #3235002

      Reply To: Locked Cells Excel

      by mike_dee · about 17 years, 2 months ago

      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

  • Author
    Replies
Viewing 2 reply threads