Copy conditional format to rows below

[Hoot]

I have a formula for conditional format set up on columns H1 and J1. It works
great for what I need. The problem is that I would like to fill-down the
formula to the rows below it in the worksheet without having to re-type each
formula using the correct row number. I am using Excel '97 and cannot figure
out how to do this. Can anyone out there help with this function in an old
Excel version?

 

[Spiky]

I have a formula for conditional format set up on columns H1 and J1. It works
great for what I need.  The problem is that I would like to fill-down the
formula to the rows below it in the worksheet without having to re-type each
formula using the correct row number.  I am using Excel '97 and cannot figure
out how to do this.  Can anyone out there help with this function in anold
Excel version?

Do you know how Relative and Absolute references work? They are shown
in formulas with or without dollar signs ($).

Why don't you show us a formula, someone can troubleshoot it for you.

 

[David Biddulph]

You should be able to use Format Painter, or Copy and Paste Special/ Format.

If it isn't working properly, check on the difference between relative and
absolute addressing.

What is your CF formula?

 

[xlm via OfficeKB.com]

I have a formula for conditional format set up on columns H1 and J1. It works
great for what I need. The problem is that I would like to fill-down the
formula to the rows below it in the worksheet without having to re-type each
formula using the correct row number. I am using Excel '97 and cannot figure
out how to do this. Can anyone out there help with this function in an old
Excel version?

Click on the formula to go into edit mode and in your formula where you need
to
change it back to the correct row number, put $ sign by entering F4 key once.
This will put an absolute reference, and then copy down.

HTH