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

Thread: Formatting text in cells

  1. #1
    Guest

    Default

    Is it possible to allow formatting of text (i.e. bold, italics, etc.) if the worksheet is protected and certain cells unlocked? For instance, we use a project setup sheet, where all cells are locked except those for entering the data. However, if a revision is made, we would like to be able to change the text in the revised cells to bold. Any help would be appreciated.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi --

    Formulas can to take actions only return result BOLD is an action.

    You need VBA for that, is this ok.

    Script will be simple as target as column A or whatever

    What you need??

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    Guest

    Default

    Hi
    If your Worksheet is protected, you will not be able to change the format of any cells even those that were unlocked and are subject to revision. You could however format the Unlocked cells to Bold before protecting the Worksheet -- this would definitely do the job, if the Unlocked cells were emply before protecting the Worksheet, otherwise you may have to use a VBA solution.
    HTH
    Yogi Anand -- ANAND Enterprises



    On 2002-03-03 14:18, Anonymous wrote:
    Is it possible to allow formatting of text (i.e. bold, italics, etc.) if the worksheet is protected and certain cells unlocked? For instance, we use a project setup sheet, where all cells are locked except those for entering the data. However, if a revision is made, we would like to be able to change the text in the revised cells to bold. Any help would be appreciated.

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
  •