Does anyone know why my drop down list doesn’t change all of the merged cells colours (conditional formatting applied with a "Text that Contains" value) when changing between the different list options? It changes x2 of the cells and leaves x1 the previous colour. Seems to only do it when the merged area is made of x3 cells ( I know merged cells are bad) Drop downs are made with Data Validation.