Formatting text in cells

Mar 3rd, 2002, 03:18 PM

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.

Jack in the UK · Mar 3rd, 2002, 03:22 PM

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

Mar 3rd, 2002, 04:41 PM

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

Quote:

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.

Mar 3rd, 2002, 03:22 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 3rd, 2002, 03:18 PM	#1
Guest Posts: n/a	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.