+ Reply to Thread
Results 1 to 2 of 2

Problem with Conditional Formatting

  1. #1
    Registered User
    Join Date
    02-10-2009
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    58

    Problem with Conditional Formatting

    I had one large sheet with a number of related items such as "kindred 6210" which has two entries 6210014 and 6210040" in the attached example.

    I decided to make each kindred its own sheet, so I copied each data set related to that kindred to its own sheet.

    Now when I make an entry that should have triggered a response such as turning a cell in the "contact column" red when an "N: is entered, nothing happens, the cell remains colorless.

    The instructions are still there in "managing conditional formatting" rules, but none of the several that are there work. The same holds true for all the "new" sheets.

    Anyone know why? Could certainly use your help.

    Thanks
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-10-2009
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    58

    Re: Problem with Conditional Formatting

    Please ignore this post. It doesn't have the proper attachment. The next one will.

+ Reply to Thread

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