Hi Experts!
For reporting purpose i need to auto highlight the multiple strings in a cell with red bold color. It is difficult have many cells contains remarks and every time hard to highlight manually with red bold font .
The file is attached first part is actual status in column A2 and the results required which need like in Column A4.
Last edited by farrukh; 04-06-2017 at 10:38 AM.
You cannot apply fonts (color, bold etc) to just a part of a cell with formulas or conditional formatting, you either apply it to the whole cell or you dont apply it. You would need VBA/macro for that
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
Please provide any solution ... VBA as you mentioned
please help me out ...
I've moved your thread to the appropriate section and will add VBA to the thread title for you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
jindon , offered a nice solution here, in post#9.
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.
Merged cells...
Please Login or Register to view this content.
jindon Thanks the results are fine . One thing more the remarks are getting from formula cell =N2, when i try to run with formula cell all the remarks of the get red color . Is there any way it works with formula cell?
same case in post # 6
Capture.JPG
No.
If the cell is the result of formula or numeric value, it needs to be converted to a constant string value to partially format the cell.
jindon many thanks last thing if i start string like TSF-1: FMF-1: GSM-2: SPS: So on , where i need to change because when i trying to ommit 1. 2. 3. the code not changing the color font?
Please Login or Register to view this content.
I Mean like below and very sorry above of my head to get in my brain pattern
HTML Code:
Capture.JPG
Upload a workbook with before/after to avoid confusion.
Please find uploaded file.
Change pattern in test4
Please Login or Register to view this content.
Wonderful muchAppreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks