SimonJensenAus
New Member
- Joined
- Jan 18, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello,
I have been applying some conditional formatting to some data in excel, ie: rows 4 and 9.
But when I then sort the data via highest to lowest value, the conditional formatting stays in row 4 and 9, and does not follow the data to the new row after being sorted.
Is there a way to lock in conditional formatting to follow the data after sorting?
I have been applying some conditional formatting to some data in excel, ie: rows 4 and 9.
But when I then sort the data via highest to lowest value, the conditional formatting stays in row 4 and 9, and does not follow the data to the new row after being sorted.
Is there a way to lock in conditional formatting to follow the data after sorting?