• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

A little help with Excel 2003

L

leglez

Platinum Member
Ok in Excel I have 1 column and 1882 rows and it is a list of all my music on my computer and the row tells where it is located at on my computer

Is there anything I can do in Excel that will highlight any row that has more than 256 characters? or change the color or something?
 
Go to top cell of column where data starts
1) Format --> Conditional formatting
2) Condition 1: "Formula is" "=LEN(A1)>256
3) Format: Do whatever format you want it to do if the condition is satisfied
4) Click ok
5) Then copy the first cell and paste special (formatting) for the rest of the column.

Or, more easily, just use the len() formula in an adjacent column.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top