Excel - Sort by Color and Sort Using Conditional Formatting
HTML-код
- Опубликовано: 5 авг 2024
- Sorting in Excel gives us a lot of options, but many users do not know you can sort by cell color and font color. You can also use Conditional Formatting and sorting.
Chapters/Bookmarks
0:00 Intro
0:14 Sort by color
2:47 Sort by Conditional Formatting
3:57 Put the selected cell color on top
Popular Excel videos
Title Watch Url
Excel PivotTable - Percentage of Row Totals and Five Awesome Tips • Excel PivotTable - Per...
Excel Tiered Conditional Formatting with Dates using functions AND and TODAY • Excel Tiered Condition...
Teams Online Course Promotion • Teams Online Course Pr...
Excel PivotTables Percentages - Grand Total, Parent Row Total, and Parent Total • Excel PivotTables Perc...
Excel - Turn on Multiple Filters in a PivotTable - Allow multiple filters per field Setting • Excel - Turn on Multip...
Excel - Filter a PivotTable with a Timeline • Excel - Filter a Pivot...
PivotTables - 3 Annoying Things FIXED! • PivotTables - 3 Annoyi...
Excel Add Sparklines on a Separate Worksheet • Excel Add Sparklines o...
Excel Chart Maps used with the Geography Data Type • Excel Chart Maps used ...
Excel Concatenate Text and Dates with the TEXT function • Excel Concatenate Text...
Tasks by Planner in Teams - Recurring Tasks - New Feature • Tasks by Planner in Te...
Excel - Insert a blank row after every row or every Nth row • Excel - Insert a blank...
#msexcel #chrismenardtraining #exceltraining #microsoft #microsoftexcel
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ RUclips keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week! Хобби
Direct and to the point! Useful information.
Thank you
James
Thank you.
Love your content its so rigjt to the point that and easy for me to understand. For soo long I have literally RAN from anything that says "excel"😂 but little by little im starting to feel good when I watch your videos
Great to hear! Don't fear Excel. :-)
That was absolutely fabulous! I appreciate it! See ya soon.
Glad you enjoyed it!
What if I did conditional formating for say multiple days that are in different columns. This sorting function will be able to apply ?
3.30 this method don't working in the updated versions ☹
I just tested and it still works.
I do not see the dialog box when I click on sort to choose levels
It is definitely there in the desktop versions. What version are you using?
@@ChrisMenardTraining it's windows 10
what did steaven did🤣🤣🤣🤣🤣🤣