FDibbens, here's a sample.

Please enter an 'X' in the first column. When the X is inserted, the other cells in that column become formatted.

I had to format each of the three cells in that column to get this to happen.

I want to be able to copy across to the other columns. But only format the relative column the X is in.

thanks.


Book1.xlsx