Question description:
This user has given permission to use the problem statement for this
blog.
Hi, I am just trying to modify the format within a string after a specific condition. For Example: If a specific value is found, then apply some specific format (bold, borders, etc)
Solved by V. W. in 26 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
17/04/2018 - 02:00
Hi
Excelchat Expert
17/04/2018 - 02:00
Welcome to Got it Pro
User
17/04/2018 - 02:00
Thanks, I am glad to receive your help too
Excelchat Expert
17/04/2018 - 02:01
Sure.. Do you have any excel sheet?
User
17/04/2018 - 02:01
Sure
Excelchat Expert
17/04/2018 - 02:01
Can you please share your excel sheet and conditions to format the cells.
User
17/04/2018 - 02:02
Is it useful if I paste it there?
User
17/04/2018 - 02:03
The text is in spanish but its not important.
Excelchat Expert
17/04/2018 - 02:03
Ya..fine.
Excelchat Expert
17/04/2018 - 02:03
Ok. Please let me know your conditions to format the cell.s
User
17/04/2018 - 02:04
as you can see, there are several code options. I want the final user to choose a code (he can type it anywhere else) and then I want to change the format on the list
User
17/04/2018 - 02:04
if he types 501, then the formula I need should allow me to find that line on the list, and then apply border format and bold, if posible blue font collor and red border
Excelchat Expert
17/04/2018 - 02:05
ok.. Let me check but he will type 501 in Any of the cells is it?
Excelchat Expert
17/04/2018 - 02:05
Or Is there any specific cells.
User
17/04/2018 - 02:06
I can choose any position or cell where he will type it
Excelchat Expert
17/04/2018 - 02:06
ok.. Let me share one sheet. please check and confirm.
User
17/04/2018 - 02:07
My first idea was to use a combo list and then find the value chosen within the combo to apply the format, but thats more complicated than just askingthe user to type the chosen code, even though, the combo list was a more elegant solution
Excelchat Expert
17/04/2018 - 02:08
Please check this sheet
[Uploaded an Excel file]
Excelchat Expert
17/04/2018 - 02:08
Request you to check this sheet
User
17/04/2018 - 02:08
I am opening it
Excelchat Expert
17/04/2018 - 02:08
Ok.
Excelchat Expert
17/04/2018 - 02:09
If you enter code in G13 then automatically your codes will be highlighted in B column
User
17/04/2018 - 02:09
yes, thats a way it should or could work
User
17/04/2018 - 02:10
My first idea was to use a combo list and then find the value chosen within the combo to apply the format, but thats more complicated than just askingthe user to type the chosen code, even though, the combo list was a more elegant solution
Excelchat Expert
17/04/2018 - 02:10
yes....Because you need to get the input from your user in some specific cells correct.
Excelchat Expert
17/04/2018 - 02:10
yes.. If you use combo then it will be difficult to select.
User
17/04/2018 - 02:10
Yes, or through a form fixture
Excelchat Expert
17/04/2018 - 02:10
ok. let me create dropdown.
User
17/04/2018 - 02:11
Ok. Then lets ask the user to type the code in some specific cell
User
17/04/2018 - 02:11
or dropdown which might be more elegant
Excelchat Expert
17/04/2018 - 02:12
Ok. please let me know what needs to be done.
Excelchat Expert
17/04/2018 - 02:13
Do you want Combo box?
User
17/04/2018 - 02:13
If it is possible it would be even better I guess
Excelchat Expert
17/04/2018 - 02:13
Ok. let me share the option.
Excelchat Expert
17/04/2018 - 02:16
Check this sheet
[Uploaded an Excel file]
User
17/04/2018 - 02:18
I 'llopen it right away
Excelchat Expert
17/04/2018 - 02:18
Is it fine?
Excelchat Expert
17/04/2018 - 02:18
ok.
Excelchat Expert
17/04/2018 - 02:20
?
User
17/04/2018 - 02:20
I think it does what I need
User
17/04/2018 - 02:20
cant find the way you didit
Excelchat Expert
17/04/2018 - 02:20
cool :)
Excelchat Expert
17/04/2018 - 02:20
ok. Let me explain...
User
17/04/2018 - 02:21
thanks, I looked at the conditional formating rules bt there are none
Excelchat Expert
17/04/2018 - 02:21
its there.
User
17/04/2018 - 02:21
Yap
Excelchat Expert
17/04/2018 - 02:21
Just place cursor in B8.
User
17/04/2018 - 02:21
now I found the rule
Excelchat Expert
17/04/2018 - 02:21
ok. Fine.
User
17/04/2018 - 02:21
Ok, the cursor is in B8
Excelchat Expert
17/04/2018 - 02:22
you got conditional formatting rules correct.
Excelchat Expert
17/04/2018 - 02:22
Let me explain from step 1.
User
17/04/2018 - 02:23
Ok
Excelchat Expert
17/04/2018 - 02:23
First step : Goto Developer --> insert -- Form Controls - Select Form Controls --->Combobox
Excelchat Expert
17/04/2018 - 02:24
Step 2: Right click the combo box --> Goto Control --- Input range Select the codes column --> and cell link - select any blank where you would like to display the selected codes ( example : D1)
User
17/04/2018 - 02:24
yes
User
17/04/2018 - 02:24
I can understand it now, dont worry.
Excelchat Expert
17/04/2018 - 02:24
ok cool.
User
17/04/2018 - 02:25
You thought it in a very simple and efective way
User
17/04/2018 - 02:25
I really appreciate it
Excelchat Expert
17/04/2018 - 02:25
Request you to provide your valuable feedback and remarks.
Excelchat Expert
17/04/2018 - 02:25
Thank you.....
Excelchat Expert
17/04/2018 - 02:25
Request you to end the session to support other users :)
Excelchat Expert
17/04/2018 - 02:25
Have a fantastic day!
User
17/04/2018 - 02:26
Ok. thank you very much. I
User
17/04/2018 - 02:26
You too
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.