Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
confuzedagain
 
Posts: n/a
Default 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   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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 02:56 PM
Find text in cell, copy row to new sheet Ajay Excel Discussion (Misc queries) 6 June 29th 05 08:40 AM
Amount of Data in a Cell Displayed On Screen/Print James H Excel Discussion (Misc queries) 3 April 27th 05 06:47 PM
find data from other sheet Jaladino Excel Worksheet Functions 1 February 24th 05 06:18 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 09:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"