Hi all, i have a Userform3 that has 2 comboboxes on it one selects a name the other selects a date, when clicking the command button how do i get to search through arr = Array("Week1", "Week2", "Week3", "Week4", "Week5", _
"Week6") to find the date and when it does offset(1,x) and change colour lets say to Red where x would be dependent on the name in the combobox e.g offset(1,1) would be Lauren offset(1,2) would be Emma and offset(1,3) would be Cheryl, then once they have had their holiday and the colour change is older than one week turn the cell colour back to its original colour (they are different for each girl), The dates appear only in column A in the places listed below:

Range("A1")
Range("A49")
Range("A97")
Range("A145")
Range("A193")

Probably trying to do too much here!, all help much appreciated!

Regards,
Simon