Formatting edit: copy paste

[SirHart]

Hey everyone,

I am building a mass document in excel 2003 for event planning and want to be able to copy paste my conditional formatting from one event to the next and then not have to manually edit every the target cells of every row again.

Is there a way to do this? The problem is that each row has a different formula.

An example:

Row 1:
conditional formatting, cell B10
=($B$6-TODAY())<255 turn cell red
=($B$6-TODAY())<270 turn cell orange
=($B$6-TODAY())<285 turn cell yellow

Row 2:
conditional formatting, cell B11
=($B$6-TODAY())<180 turn cell red
=($B$6-TODAY())<195 turn cell orange
=($B$6-TODAY())<210 turn cell yellow

Row 3:
conditional formatting, cell B12
=($B$6-TODAY())<45 turn cell red
=($B$6-TODAY())<60 turn cell orange
=($B$6-TODAY())<75 turn cell yellow

Is there a way when I copy past those cells into another event that I can change all of the $B$6 's into $F$6 's without doing it cell by cell. I have a good 30 cells I have to change manually each time.

**Note: I can not switch the rows and columns, I would run into the same problem with another set of formatting.

Any help would be very appreciated. Very sick of plugging numbers all day!

 

[SirHart]

Just figured it out. Sorry about that!

Just had to absolute the Row and not the column