Place specfic text in cell based on text in an adjacent cell
Solved/Closed
RKF-CCM
TrowaD
- Posts
- 1
- Registration date
- Tuesday August 30, 2016
- Status
- Member
- Last seen
- August 30, 2016
TrowaD
- Posts
- 2888
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- August 16, 2022
Related:
- Based on the values in cells b77 b81
- Based on the value in cells b77 - Best answers
- Based on the value in cells b77 b81 - Best answers
- Based on the values in cells b77 b81 what function can automatically return the value in cell 77 ✓ - Forum - Excel
- Fixing populating values into textboxes based on showing data in listbox ✓ - Forum - Excel
- Based on the values in cells b77 b81 which function can automatically return the value in cell 77 ✓ - Forum - Excel
- Conversion of values already present in cells ✓ - Forum - Excel
- Find values based on colum and sum in a table - Forum - Office Software
3 replies
TrowaD
Sep 1, 2016 at 11:25 AM
- Posts
- 2888
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- August 16, 2022
Sep 1, 2016 at 11:25 AM
Hi Fergie,
You want to enter text in the cell and not change it's format, so why use conditional format?
Put the IF formula in B1. B1 will show False when A1 doesn't contain "Non-concur". To prevent that use this: =IF(A1="Non-concur","Sample text","")
Best regards,
Trowa
You want to enter text in the cell and not change it's format, so why use conditional format?
Put the IF formula in B1. B1 will show False when A1 doesn't contain "Non-concur". To prevent that use this: =IF(A1="Non-concur","Sample text","")
Best regards,
Trowa
Mazzaropi
Sep 2, 2016 at 06:44 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Sep 2, 2016 at 06:44 PM
Fergie, Good evening.
The Trowa's formula:
B1 -->
=IF(A1="Non-concur","Sample text","")
works perfectly for your case.
Did you checked if there is any rule of Conditional Format acting at B1?
It's a simple case and there is no reason for not work.
Belo Horizonte, Brasil.
Marcílio Lobão
The Trowa's formula:
B1 -->
=IF(A1="Non-concur","Sample text","")
works perfectly for your case.
Did you checked if there is any rule of Conditional Format acting at B1?
It's a simple case and there is no reason for not work.
Belo Horizonte, Brasil.
Marcílio Lobão
Found something that worked:
=IF(OR(A1="C",A1=""),"","Sample Text")
This formula goes into A2 and leaves A2 blank even when he user has not selected a value from the validation list in A1.
Thanks.
=IF(OR(A1="C",A1=""),"","Sample Text")
This formula goes into A2 and leaves A2 blank even when he user has not selected a value from the validation list in A1.
Thanks.
TrowaD
Sep 6, 2016 at 12:03 PM
- Posts
- 2888
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- August 16, 2022
Sep 6, 2016 at 12:03 PM
Hi Fergie,
That doesn't make sense, since anything other then the letter C or empty cell will produce the result text "Sample Text".
But if it works for you, than we are happy.
Best regards,
Trowa
That doesn't make sense, since anything other then the letter C or empty cell will produce the result text "Sample Text".
But if it works for you, than we are happy.
Best regards,
Trowa
Sep 1, 2016 at 10:08 PM
Thanks for the response. I have tried that and did not get anything in the target cell.
I also tried negative logic, that is =IF(A1<>"Concur","Sample text",""), which did work but, the problem is the Sample text shows up in B1 in the rows where the user has not selected a choice of Concur or Non-concur. I tried conditional formatting on B1 to change font to white so that text doesn't show, that did not work either.