Per the preface, I have a cell that has validation rules of "Concur, Non-concur". If the user selects "Non-concur" for that cell, I want to place text into the adjacent cell to the right.
For example, if A and B are the cells in question, and I select "Non-concur" as the value for A1, I want the then place a string in B1. I have tried using a conditional formatting formula in B1 such as =IF(A1="Non-concur","Sample text",). That formula does not cause an error, yet it gives no results. That is, the string "Sample text" does not appear in B1.
Does anyone have any suggestions for getting this done?
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.
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.