Hi There,
My level of coding in VBA is very basic, so any help is appreciated. I have a bi-weekly budget spread out over 3 years. There are 6 columns associated with every bi-weekly payment. The first two columns deal with Budget (col #1) and Actuals (col #2). The four following columns deal with added information to help me with budget decisions. My budget items are spread down the rows (over 500).
Currently, there's some conditional formatting in column #2 that I copy (I double click Format Painter) and then manually click every 6th cell to the right (the next bi-weekly column #2) to paste the conditional formatting. I need to do this 26X3 times.
Can someone help me create a VBA code to automatically do the formatting for me? Thanks
My level of coding in VBA is very basic, so any help is appreciated. I have a bi-weekly budget spread out over 3 years. There are 6 columns associated with every bi-weekly payment. The first two columns deal with Budget (col #1) and Actuals (col #2). The four following columns deal with added information to help me with budget decisions. My budget items are spread down the rows (over 500).
Currently, there's some conditional formatting in column #2 that I copy (I double click Format Painter) and then manually click every 6th cell to the right (the next bi-weekly column #2) to paste the conditional formatting. I need to do this 26X3 times.
Can someone help me create a VBA code to automatically do the formatting for me? Thanks