Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 3 of 3 FirstFirst 123
Results 21 to 22 of 22

Thread: Conditional formating

  1. #21
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-08 14:15, Barry Katcher wrote:
    I agree with Nimrod that locking cells with formulas is the way to go - prevents users from overwriting them. I also think Brian from Maui has the right idea - changing the format of unprotected cells so that the user knows which cells he/she/it may enter to.

    Chris Davison just helped me last week with some code to emulate Lotus' display of unpretected cells with blue font and protected with black. You run the code whenever you open a new workbook and it goes to the first, second and third sheet of the workbook, locks all the cells in each and, when you un-lock any cells, converts the font in those cells to blue. This code could be modified to show all unproted cells with, say, light yellow background (light yellow won't show on a printout), even more helpful to users, since the blue font only shows after you enter something to the un-locked cells.

    Let me know if you want this code and I'll paste it onto a reply.

    _________________
    ...and I always put the seat down.

    [ This Message was edited by: Barry Katcher on 2002-05-08 14:16 ]
    Barry !!!

    me ?

    code ?!?!

    I don't think so !!

    from memory, I'm pretty sure my method was a conditional formatting formula which you apply to all sheets....

    the precise formulae in the condition(s) was looking at whether =cell("protect") gave a TRUE or FALSE result and formatted the font accordingly

    it looks as though Nimrod has already covered this though in the posting just above yours

    me and code...LOLOL... that's about as likely as Gary Glitter being hired in a creche...


  2. #22
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    me ?

    code ?!?!

    I don't think so !!


    Hi Chris:
    Let us not be so modest now! ... I read you posting some code the other day -- and by the way why do you think your name begin with C ... one day we will be calling you Chris -- the Code Man.

    Regards!



    [ This Message was edited by: Yogi Anand on 2002-05-11 13:43 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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