But what if you just copy the cells that are already formatted then paste  special  formatting?
Hopefully someone else has a better way to do the conditional formatting. Here's what I did. In cells BZ2:BZ33 I repeated the sequence 1,2,3,4. I arbitrarily chose cell C2 as my starting area. Click cell C2, go to Format  Conditional Formatting.
Condition 1 = Formula is
In the box next to it I typed =$I2=4
Now drag down from cell C2 to cell e33. This worked for me in Excel 2003. It is klugy.
Conditional Formatting  Heavy boarder to the bottom every fourth row

0 Votes

0 Votes
But what if you just copy the cells that are already formatted then paste  special  formatting?
Hopefully someone else has a better way to do the conditional formatting. Here's what I did. In cells BZ2:BZ33 I repeated the sequence 1,2,3,4. I arbitrarily chose cell C2 as my starting area. Click cell C2, go to Format  Conditional Formatting.
Condition 1 = Formula is
In the box next to it I typed =$I2=4
Now drag down from cell C2 to cell e33. This worked for me in Excel 2003. It is klugy.
Conditional Formatting  Heavy boarder to the bottom every fourth row
The sheet has preprinted names, one for each row. These change on a daily basis and are updated via "cut & paste" from another excel sheet.
In addition, the form has 12 "in"/"out" columns per row and I would like to apply 10% shading each of the 6 "out" columns.
I would like to be able to cut and paste new names onto the sheet or add / delete rows without having to reformat the cells all the time. I believe that this can be done by using conditional formatting but do not know what formula to use.
I am using Excel 2003.
Can anyone help?