Using Data Validation, I have created a dependent list (based on instructions
found on the Contextures web site:
http://www.contextures.com/xlDataVal02.html).
I want to create a conditional format whereby if someone changes the
selection in the first data validation list without changing the
corresponding selection in the dependent list (i.e., second list), the cell
value in the dependent list will turn red.
Can anyone tell me how to go about doing this?
Thanks, Bob