-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
conditional formatting
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,197
- Office Version
- 365
- Platform
- Windows
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.
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.
Upvote
0
