LinkBack URL
About LinkBacks
Hello,
I`m having trouble with finding a function to highlight a specific one character substring but not the cell. Example like Text only the "e" and in numbers lik 54321 only the "3"
Thanks for any asistance.
Hello,
I`m having trouble with finding a function to highlight a specific one character substring but not the cell. Example like Text only the "e" and in numbers lik 54321 only the "3"
Thanks for any asistance.
But what is the logic behind which character is to be highlighted?
Cheers!
Deep Dave
Using either
=Find()
or
=Search()
Functions
THis is not possible with regular functions (or with Conditional Formatting), you will need VBA code for this
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
No, I mean how do you know which character is to be highlighted?Originally Posted by Daddy007
You might need something like this -
Certainly not the most optimized code, but will able to do that once your requirement is clear.
Please Login or Register to view this content.
Last edited by NeedForExcel; 04-29-2015 at 02:24 AM.
Thanks for the reply, I am a noobie at excel
any asistance in finding a VBA code is greatly appreciated.
This VBA code works great, it does highlight one character in the first active cell.
But not the whole sheet, and I`m trying to highlight the exact character that I type in the cell.
Example A1:CP1257
7865
2341
7890
Adfg
RTHm
jhuTzE
Then I type in a text character E it highlights all the E`s on the sheet,
Or I type in the number 7 then it it highlights all the 7`s on the sheet. If someone could optimize it that way it would really help me.
Thanks again for your asistance,
Greatly Appreciated.
Last edited by Daddy007; 04-29-2015 at 06:48 PM.
Hello everyone,
Is there a VBA code I could use to highlight a particular substring only and not the cell.
Example
XYZ
789
tzy
471
ZDR
057
I would type the letter Z and the z would be highlighted everywhere it was found in the cell and
the entire sheet.
Or
The substring number 7 that I typyed to be found and highlighted within the cell but not the cell only.
Any asistance is greatly appreciated.
I don't believe it is possible to 'highlight' in Excel. However it would be possible to change the colour of the Substring
Please Login or Register to view this content.
!If all your troubles are solved, then so is the thread. Show this by marking it so using thread tools at the top of the page.
If I helped do this, then please show your appreciation by awarding rep points.
<------ Button for that is over there
Edit: Removed post, it was incorrect.
Try
Please Login or Register to view this content.
- Battle without fear gives no glory - Just try
Here!
Try this -
Make sure you select the range before running the code.. The smaller then range, the faster the code will run..
Please Login or Register to view this content.
Last edited by NeedForExcel; 04-30-2015 at 03:12 AM.
Pls take a look to forum rules before you post again because this is a duplicate thread and does not comply with rule#5 of our forum.
Since you are a new member and also you have replies in both of your threads just for this time i'll merge your 2 threads.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Try
Please Login or Register to view this content.
Wonderfully Coded,
Exactly what i needed, is there a way the highlighted substring could be edited to change color like red, blue, green, or yellow.
Thanks again & again.
For my code
Please Login or Register to view this content.
I would like to thank you very much for your work on this code, it was wonderfully! coded.
This is exactly what i needed to accomplish my task.
Thanks again!
Thank you for your splendid work on this code, just what i needed.
This will get the job done.
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks