May 18 2023 10:49 AM
I have a Yes,No, drop down list in a cell. If "No" is selected, I want the fill color of the adjoining cell to change color. How can I do this? Thx
May 18 2023 11:15 AM
May 18 2023 03:28 PM
@mtarler Thanks for the note...
Here's a little more clarity....my apologies.
If "NO" is selected in the drop down in the cell under "Response", I want to repeat the same response, in the Cell next door, under Baseline" and have the cell fill be a specific color.
Thx
May 18 2023 06:55 PM
@Anthony Blackburn so I don't know why you want to repeat that 'no' but the formula can simply be =B3 if the response is in B3 and then conditional formatting of that cell (if that is the only cell you want formatted) can use one of the preset formats like 'text that contains'