Excel Made Easy 9: Complete Conditional Formatting, Formatting Date, Using Format Painter
What to expect:
What is conditional formatting?
Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that meet certain criteria. It is most often used as color-based formatting to highlight, emphasize, or differentiate among data and information stored in a spreadsheet.
Conditional formatting enables spreadsheet users to do a number of things. First and foremost, it calls attention to important data points such as deadlines, at-risk tasks, or budget items. It can also make large data sets more digestible by breaking up the wall of numbers with a visual organizational component. Finally, conditional formatting can transform your spreadsheet (that previously only stored data) into a dependable “alert” system that highlights key information and keeps you on top of your workload.
Originally a powerful feature of Excel, other spreadsheet applications have also adopted this functionality.
How do I Use Conditional formatting in Excel?
Conditional formatting allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value. To do this, you'll need to create a conditional formatting rule.
For example, a conditional formatting rule might be: If the value for a range of cell is less than 2000 naira, color the cell red. By applying this rule, you'd be able to quickly see which cells contain values less than 2000 naira.
What is conditional formatting used for?
Conditional formatting enables you to apply special formatting to cells in your spreadsheet that meet certain criteria. Excel has a sizable library of preset conditions that you can apply fairly simply, or you can create your own conditional formatting rules using Excel formulas. This guide will provide in-depth step-by-step examples of the most popular conditional formatting functions for basic and advanced users in Excel 2016.
Conditional formatting provides another way to visualize data and make worksheets easier to understand.
What is an example of conditional formatting
Explained in video
What is Format painter?
Format Painter is used when you want to copy formatting from one item to another. For example if you have written text in Word, and have it formatted using a specific font type, color, and font size you could copy that formatting to another section of text by using the Format Painter tool.
How to change date format in Excel
Select the dates whose format your want to change, or empty cells where you want to insert dates.
Press Ctrl+1 to open the Format Cells dialog. ...
In the Format Cells window, switch to the Number tab, and select Date in the Category list.
Under Type, pick a desired date format.
Download Class 9:
https://drive.google.com/open?id=1up5...
Other Video Resources
Excel Made Easy:Introduction
• Excel Made Easy 1: Introduction
Excel Made Easy: Auto fill feature, Basic Operators, What-if-scenarios
• Excel Made Easy 2: Auto fill feature, Basi...
Excel Made Easy Task 1: Simple Exercise to Unders
• Excel Made Easy Task 1: Simple Exercise to...
Excel Made Easy: Use your Smartphone and Excel Effectively
• Excel Made Easy: Use your Smartphone and E...
Excel Made Easy 3: Design a Simple Template, Insert Tables, Charts
• Excel Made Easy 3: Design a Simple Templat...
Excel Made Easy 4: More Excel Functions, COUNT, COUNTA, COUNTBLANK, SUM, MIN, MAX, AVERAGE
• Excel Made Easy 4: More Excel Functions, C...
Excel Made Easy 5: Quickly Create Charts in Excel, Bar Charts, Pie Charts, Line charts
• Excel Made Easy 5: Quickly Create Charts i...
Excel Made Easy 6: Complete Guide to quickly Customize any Excel Chart
• Excel Made Easy 6: Complete Guide to quick...
Excel Made Easy 7: Using CONCATENATE Function and "&" Operator
• Excel Made Easy 7: Using CONCATENATE Funct...
Excel Made Easy 8: Relative and Absolute Cell References Complete
• Excel Made Easy 8: Relative and Absolute C...
"Excel Made Easy" is a complete guide for learning Microsoft Excel which covers in-depth knowledge about different excel formulas and functions, conditional formatting, excel Lookup, excel macros & VBA in Ms Excel.
A comprehensive tutorial on Excel covering most essential features for business professionals, students or anyone that wants to learn how to use Excel.
Learn Excel
Connect:
Quora: https://www.quora.com/profile/Onuzuri...
Behance: https://www.behance.net/onuzurike_chu...
Medium: / onu663
Linkedin: / chukwuagozie-onuzurike
Excel Made Easy 9: Complete Conditional Formatting, Formatting Date, Using Format Painter