text: Just make your IF statement with an absolute reference to the data.  For example, instead of =IF(D7=23,"GOOD","BAD") write =IF($D$7=23,"GOOD","BAD").  When you copy the formula, it will automatically reference the D7 location.