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?


--
confuzedagain
------------------------------------------------------------------------
confuzedagain's Profile: http://www.excelforum.com/member.php...o&userid=29439
View this thread: http://www.excelforum.com/showthread...hreadid=491489

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