Copy conditional format to rows below
 

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?

Copy conditional format to rows below
 

On Dec 24, 9:32*am, Hoot wrote:
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?

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.

Copy conditional format to rows below
 

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?
--
David Biddulph

"Hoot" wrote in message
...
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?

Copy conditional format to rows below
 

Hoot wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200812/1