I'm working on a spreadsheet with a lot of conditional formatting.
But I've got one thing that I'd like to change but isn't working as wanted.
I'd like to highlight an individual row ( lets say Row 9) if the cell J9 doesn't contain the word "PUBLIC".
Now I used a formula to determine which cell to use the conditional formatting on. I've used the formula =$J$9<>"PUBLIC"
The problem is that we have to insert rows above sometimes and with that the conditional formatting moves down. E.g. if I insert a row above, the formula changes to =$J$10<>"PUBLIC"
How is it possible to keep the formatting always on Row 9?
Thank you so much for your help