Place specfic text in cell based on text in an adjacent cell [Solved/Closed]
Posts Tuesday August 30, 2016Registration date
August 30, 2016
Aug 30, 2016 at 07:24 PM - Latest reply: TrowaD2314
Posts Sunday September 12, 2010Registration dateModeratorStatus
March 22, 2018
- Sep 6, 2016 at 12:03 PM
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?