+ Reply to Thread
Results 1 to 2 of 2

Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data

  1. #1
    Registered User
    Join Date
    12-07-2005
    Posts
    4

    Question Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data

    How would one go about finding the cell that contains the MAX info, or say any/all cells that exceeds 8,000 characters/spaces in a Excel page?

  2. #2
    Sloth
    Guest

    RE: Find MAX data in sheet (Cell) - Any cell that exceeds X amount of

    1. Highlight the entire document
    2. Select Format->Conditional Formatting
    3. Select "Formula Is"
    4. Input this formula
    =LEN(A1)>8000
    5. Format with something obvious like green background

    If you highlight a select amount of the sheet, replace A1 with the top left
    cell in the highlighted area.

    "confuzedagain" wrote:

    >
    > How would one go about finding the cell that contains the MAX info, or
    > say any/all cells that exceeds 8,000 characters/spaces in a Excel page?
    >
    >
    > --
    > confuzedagain
    > ------------------------------------------------------------------------
    > confuzedagain's Profile: http://www.excelforum.com/member.php...o&userid=29439
    > View this thread: http://www.excelforum.com/showthread...hreadid=491489
    >
    >


+ 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