Get instant live Excel expert help to learn how to copy and paste conditional formatting to another cell

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

hi I have a spreadsheet that uses conditional formatting. ive created a new formatting rule -> use a formula to determine which cells to format. My formula is =if(bg7 = true, true, false) it works but I want to copy and paste it to rows below. ive used the format painter button but it doesn't automatically change the cell from bg7 to bg8 to bg9 etc. seems like I have to do manually
Solved by E. J. in 21 mins
I'm trying to copy 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 E. U. in 29 mins
Need help with how to copy conditional formatting and formatted formula to other cells.
Solved by K. Y. in 16 mins
Conditional formatting across a column Y6>=$C$2 Format J6 I've tried relative and absolute referencing to the cells and used format painter to copy down column J but it all formats when it shouldn't, same when using colum referencing rther than cell. So checking if a date cell is greater than or equal to a date in cell C2 and if it is to change the format of cell in column J. Should I be doing this a different way?
Solved by F. Q. in 16 mins
I have a row on one sheet with conditional formatting every other row for a status. If that status is * it turns red. Now when that status is red, I need to copy that whole entire row including status onto the next sheet labeled Outstanding. If another row is entered with the same status, I need that copied into the Outstanding sheet right below the next one. Can this happen?
Solved by Z. A. in 16 mins
Greetings! I'm trying to copy the following conditional formatting formula to different cells, but I need the cell reference to change to reflect the cells where they're being pasted, ie. S16:T16, S17:T17, S18:T18, etc. I'm looking for a quicker way to input the formulas so that I don't have to put them in individually, as there are hundreds that need to be inputted. If you can assist, I would greatly appreciate it. Also, the point of this formula is to highlight the adjacent cells that have the same value. =COUNTIF($S$15:$T$15,INDIRECT(ADDRESS(ROW(), COLUMN(), 4))) > 1
Solved by G. H. in 27 mins
I want to know how to do excel copy Conditional formatting, but also the change the rule it applies to based on the cell it is in.
Solved by I. U. in 29 mins
Automatticaly copy row from Sheet1 to another sheet if cell in certain column from Sheet1 has specific conditional formatting.
Solved by X. L. in 15 mins