I have a column of cells and each cell has data validation making the
user pick Yes or No from the drop down list. I would like my vba code
to run after *after* the user makes a choice of Yes or No.
For example, the user picks Yes, the cell the next column changes the
Pattern to light grey so it looks like the cell is greyed out.