I have a report that I export to Excel where certain cells have color highlights to identfy a condition of origin for the data in the cells. I need to sort the worksheet and keep the color highlights with the original cells. Is there any way to do this? Thanks.
-
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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Maintaining color highlights when sorting
- Thread starter PDHRacer1
- Start date
Excel Facts
Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Similar threads
- Replies
- 8
- Views
- 354
- Replies
- 18
- Views
- 601
- Replies
- 2
- Views
- 156
- Replies
- 0
- Views
- 124
