My problem is I have a file containing if and index and match formulas. This file has month to month data and at last, total column. My problem is how to sort the file highest to lowest without loosing coloring and formatting and outlines of the file based on last total column. As I have used different colur for different month .
Remove your formatting.
Replace the formatting with conditional formatting
Select all cells
Select Home Tab and then conditional formatting
Select use Formula
Example Formula for conditional format:
=MONTH($D1)=4
Last edited by mehmetcik; 04-17-2019 at 08:37 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks