MS Excel has come with great features like Filter by color is just one them.
1. Applicable in Office 2007
2. After you apply conditional formatting from the home Icon.
3. Apply filter by clicking on Filter under the Data icon.
4. Click Filter Cell (which is A1 in this case)
5. Go to filter by color option from drop down.
6. Select the color using which you want to filter.
Also, do let me know your comments about this post and subscribe to us to receive latest updates via email
We assure you knowledge, not SPAM!
1 comments:
Thanks Dear this really helps in coding the data in colour formate. And presenting it in a much better way
Post a Comment