Results 1 to 5 of 5

Locking Conditional Formatting in Excel 2000.

Threaded View

  1. #1
    Registered User
    Join Date
    07-11-2009
    Location
    London
    MS-Off Ver
    Excel 2000
    Posts
    12

    Locking Conditional Formatting in Excel 2000.

    I have a column "g" with this conditional formatting:-

    =A2<>A3 Format Bottom Border.

    However I will pass this workbook onto someone else who will fill in the text in column "g". They will use copy/paste text from other cells or columns even other workbooks that will not have the conditional formatting.

    I have used Cells > Projection > Locked unchecked then used Tools > Protection > Protect Sheet and checked all. There does not seem to be a way to unlock the cell but protect Conditional formatting.

    Each time I copy and paste from other non formatted cells it wipes out my formatting.

    I want to lock just the Conditional formatting.

    Any advice please?
    Last edited by athegn; 07-28-2009 at 02:53 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1