Hey,
Does anyone know if it is possible to do a conditional format whereby it highlights a cell if it exceeds a certain character limit (including spaces)? I'm trying to work on one that will highlight any cells that exceed 240 characters.
Any insight would be greatly appreciated.
Thanks
Last edited by Shadefalcon; 10-01-2012 at 10:06 AM.
If you are including spaces as character. Conditional formatting> Use Formula =LEN(A1)>=240
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
hi Shadefalcon. assuming your data is in A1:A10, highlight them & go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=LEN(A1)>240
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
I tried it, but it didn't seem to work for everything. Do commas throw it off?
Wait, nevermind, I figured it out. Had to change A1 to D1 because the column I was working on was D. My bad. Thanks guys.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks