Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Find text in cell, copy row to new sheet | Excel Discussion (Misc queries) | |||
Amount of Data in a Cell Displayed On Screen/Print | Excel Discussion (Misc queries) | |||
find data from other sheet | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |