Hi to all excel pro out there,
I am using Excel 2013 and I would like to know are there any ways to auto BOLD and UNDERLINE words in my excel spreadsheet based on a database in another spreadsheet.
Kindly refer to my screenshots below for the scenario
q4juSmD.jpg
yB6DioZ.jpg
Last edited by chengp; 02-25-2016 at 03:12 AM.
Did not open your file, but assuming that that the text string is all in 1 cell, this cannot be done with forumals of Conditional Formatting, you will need VBA 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
can you show me the VBA coding to make this happen ?
Im sure we can get this for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks