I'm trying to get one cell to highlight based on which selection from the validation table is selected in another cell.
In Cell A1, I have "Choose One" to populate based on another cell.
In Cell B1, I have a validation table with Yes or No as the selections to choose from.
I want Cell B1 to highlight if A1 says "Choose One"...so other users know where to choose an answer.
Thanks!
In Cell A1, I have "Choose One" to populate based on another cell.
In Cell B1, I have a validation table with Yes or No as the selections to choose from.
I want Cell B1 to highlight if A1 says "Choose One"...so other users know where to choose an answer.
Thanks!