View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hoot Hoot is offline
external usenet poster
 
Posts: 6
Default 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?