folks, i use a formula row to update a table each week. that is, i have all the formulas in a row above the table, and then each week when the new data comes out, i copy the formula row below the table, pasting these as values. this is to keep each week of data as a static point in time row. i made a silly mistake today where i forgot to update a separate range which impacted my calculations. to avoid this happening again, i want to add a conditional format to the formula row that will work when i copy the row below the table. this is to highlight when the new number is less than last week's number. it should always be higher. i have tried a simple if statement but the applies to keeps changing to absolute