Thread: Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default 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 With QuoteReply With Quote