Hi
I have a range of cells C6:K6 which contains numbers from 3 to 9.
In a second range C18:K18 I would like to have the following (if possible):

If C6 = 3 then C18 = "X" otherwise if C6 3 then Insert a drop-down box
with values "Yes" and "No".

Can this be done?

Sandy
ps I know I posted this on Public.Excel but I then thought this was a more
appropriate section