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.