Place specfic text in cell based on text in an adjacent cell [Solved/Closed]
Ask a questionRKF-CCM1PostsTuesday August 30, 2016Registration date
August 30, 2016
Last seen - Last answered on Sep 6, 2016 at 12:03 PM by TrowaD
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?