Hi , I have used the Debra Dalgleish's Contextures website for
instructions on Dependent Lists, and it works excellent , but now I need to add items to my validation Lists , let me explain , if the user type a new element I need to add that new one to the validation list. How can I do it ?

Thank you

"Ron Coderre" wrote:

First, thanks for visiting Debra Dalgleish's Contextures website for
instructions on Dependent Lists. Now, I have a lot less expaining to do.

Since the dependent list is based on a Named List, try this:
With
A1 containing the parent list
B1 containing the dependent list
and the Named list: MyNamedList

Then
Select B1
<format<conditional formatting
Formula is: =ISERROR(MATCH($B$1,MyNamedList,0))
Click the [format] button and set your format
Click the [OK] buttons and you're done.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Bob" wrote:

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