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