Copy conditional format to rows below

  • Thread starter Thread starter Hoot
  • Start date Start date
H

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?
 
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?
Click to expand...

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.
 
Back
Top