I have a spreadsheet where I keep track of my golf score and handicap changes. In column K of the spreadsheet, I have values based on calculation in other columns. I am using conditional formatting to highlight eight cells with lowest values in column K and looking at only top 20 rows.

Every time I play a round, I add a new row at the top below the heading and still want to only look at the top 20 rows. When I add a new row, Conditional Formatting formula changes with increments to the formula values.

This causes issues with my calculation and does not highlight the correct cells.

Is there a way to keep the formula static even after inserting the rows?

This is my first post here. Will appreciate your help.