Add Dropdown to a specific Cell Color

[basketball2524]

I have the following code from a previous program I made and need help converting it.

Please Login or Register  to view this content.

I want it to do the same thing except it will only add a dropdown menu for a Cell that has a background of Yellow. Any suggestions?

[humdingaling]

from what i can see you did this in macro record but you actually did quite a few steps which are overwritten?
much of that code can be taken out actually

how many rows are you realistically going to use....creating checks for 1048576 cells to insert data validations is not good practice

[humdingaling]

Please Login or Register  to view this content.

Change the For lrow statement to the amount of rows you want to run for
i put 50 in this code
colorindex = 6 - is yellow
http://dmcritchie.mvps.org/excel/colors.htm
this website has list of colorindex numbers

This code does not clear the range of DV's prior to running thru
so it will need to be added if you it to clear all DV's prior to running
something like this prior to the FOR loop

Please Login or Register  to view this content.