In Excel 2003, I used to have my conditional formatting based upon the value of another cell in the same column. I could drag the cell to the right, as if a "fill right", and the formula, format, and conditional format would drag to the right. When I do that in Excel 2007, the formula and format will drag to the right, but the conditional formatting remains pointed to the original column. For example, I have cells X48-X61 conditionally formatted to appear red if their values are greater than the value in cell X18. In the conditional formatting dialog box, I remove the "$" from in front of the "X$18". This should allow me to drag the cells in X48-X61 to the right, so that the formulas, formats, and conditional formats get filled into cells Y48-Y61, with the conditional formatting pointing to cell Y18. However, it doesn't work. The conditional formatting for cells Y48-Y61 still point to X18. It ignores the fact I removed the "$". Is this a bug or what?