This applies to Excel 2007.

I have a column full of values that have conditional formatting that says,
if the value in this cell matches the value in cell $C$1, turn yellow. If I
type a value in C1 that matches cell A6, for example, it won't turn yellow
until I select cell A6, or edit data elsewhere in row 6.