All solutions IF Expert Solution – Excel IF Problems

Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc