Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Condtional Format Based on Cell Protection

  1. #1
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Matti:
    RE: conditional format base on LOCKED cell

    If you are going to have the formula cells locked then there is another way to change the text color without a macro.
    You can do a "conditional format" based on if a cell is locked or not !

    1-Go into Format ... conditional format..
    2-choose "formula is" from drop down
    3-type in this formual : =CELL("protect")=0
    4-make your format choices
    5-select add button
    6-type in this formula: =CELL("protect")=1
    7-make your format choices

    Done : now you have a special format for lock=1, and unlocked = 0

    <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Nimrod:

    I like your "Note: Tested on blah,blah,blah"
    maybe we should all be adding that to our post

    James

  3. #3
    New Member
    Join Date
    Dec 2003
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Condtional Format Based on Cell Protection

    Hi Nimrod

    Maybe this is too old but I feel itís best to say that your
    solution is very volatile. Iíve tried it on a new workbook
    with nothing else in it and itís switching back and forth
    between the two formatsÖ seemingly at random.

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
  •