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?