Hi Paul, was looking at your "content control conditional formatting" file and it doesn't seem to color the cell after the selection. Also after selecting one of the dropdowns I keep getting an error message in VBA "ambiguous name detected". I'm sure this is some error on my end but do you have any suggestions?