This all depends on how you've defined the source for the 2nd list.

Let's assume you have selections for list1:

Cars
Trucks

If Car is selected then the dependent list2 has these selections:

Chevy
Ford
Mopar

So you select Ford. Then you change your mind and select Trucks from list1.
However, list2 still has Ford selected and Ford is not a valid selection for
Trucks. And, if you have calculations based on these selections these
mis-matched selections can cause all sorts of problems.

So, to make a specific suggestion on how to fix this you need to provide a
lot more detail.

--
Biff
Microsoft Excel MVP


"ASYDNEY" wrote in message
...
I have two dependent pick lists (the selection in the first pick list
generates the second pick list). I would like to set up conditional color
formating so if the first pick list is altered from its original choice
and
the second pick list is not updated, that the cell changes color.

Thank you for your help