Get instant live expert help on How do I copy formatting in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
In conditional formatting in copy and the formatted formula to other cells.
Solved by K. Y. in 16 mins
I'm trying to copy the conditional formatting in cell C5 on the sheet "Skins" to D5 - T5. I'm able to copy conditional formatting when I don't have $ in my formula but when I include $ in my formula the code doesn't copy properly. This formula requires $'s. Is there a way to copy conditional formatting from one column to the next without having to manually re-write the code for each column?
Solved by S. H. in 27 mins
Hi, I've got 2 columns in Excel. The first has the quantity of an item in stock, the second has the quantity needed for a job. For the second collum, I have conditional formatting so that if the number required is greater than the stock, the cell turns red. And if it is ok (so between 1 & number in stock) then it turns green. Is there a way to copy the conditional formatting to all the other items? At the moment, (using both copy/paste, and the copy formatting brush) it copies the conditional formatting, but references it to the copied item's stock, rather than applying it to the new item's stock.
Solved by X. W. in 17 mins
Automatticaly copy row from Sheet1 to another sheet if cell in certain column from Sheet1 has specific conditional formatting.
Solved by O. Y. in 14 mins
Copy non-blank rows from range to new sheet as values keep formatting
Solved by Z. Y. in 27 mins