Welcome to the Board!
Sure. There are a few ways:
1. You can apply it to entire columns, so it doesn't matter what rows the data ends in.
- or -
2. You could use VBA to find the end of your range, and apply the Conditional Formatting just to those rows.