I would like to scan a column of data (A6:A10,000) and for any Row that has a value in column A, copy the formatting from the current row cells F & G, and paste that formatting in the same current row, cells H & I. Thanks for any help.