Results 1 to 5 of 5
  1. #1
    Bronze Lounger IanWilson's Avatar
    Join Date
    Dec 2000
    Location
    Bristol, United Kingdom
    Posts
    1,523
    Thanks
    0
    Thanked 1 Time in 1 Post

    Unprotected cells (97)

    At work I've put a spreadsheet on a shared drive where colleagues can request car parking spaces. I want them to be able to put their names in red if the request is urgent. If I lock some of the cells (such as the days and dates) then protect the sheet, they can put their names in the unlocked cells, but they can't make the text red. If I unprotect the sheet, they can format the unlocked cells in red, but they can also alter cells I want to be untouchable. Does protection have to prevent them formatting the cells?

    Ian

  2. #2
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unprotected cells (97)

    Your you can insert a column that indicates the degree of urgency by means of a list of validation and in the column where they write the names, you can make a conditional format

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unprotected cells (97)

    I think that the easiest way to do this would be to put a button on a tool bar that will unprotect the sheet, change the color, then protect the sheet again.
    Legare Coleman

  4. #4
    Bronze Lounger IanWilson's Avatar
    Join Date
    Dec 2000
    Location
    Bristol, United Kingdom
    Posts
    1,523
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Unprotected cells (97)

    So it's true that if the sheet is protected they can't change the colour? I naively imagined I could fix it so some cells were untouchable but some they could do as they wanted with.

    Ian

  5. #5
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unprotected cells (97)

    <img src=/S/gramps.gif border=0 alt=gramps width=20 height=20> Here is my suggestion
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •