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

C

confuzedagain

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

Sloth

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.
 
Top