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?
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?
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks