3 easy ways to format cells in excel | Conditional Formatting in Excel in 2020
3 easy ways to format cells in excel | Conditional Formatting in Excel in 2020. In this video we will see how to highlight cells satisfying a condition. By this tool a specific formatting can be applied 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. In this video, 3 conditions are considered for formatting cells on the basis the value in the specified cell . This lecture will be beneficial for both beginners and professionals who use Excel. It is part of the excel course having series of lectures on various concepts of Excel
This tool is available in all the versions of Excel.
In this video, following items are covered:
Based on range of numeric values
Based on a text values
On top/bottom values
Visit & Subscribe channel: / @techreflections
In coming videos more rule types & advanced features of Conditional Formatting will be explored.
Welcome to Tech Reflections (#techreflections) & I am Vikram.
Checkout Other Playlists on this channel:
Excel formula and functions:
• Excel - Formulae & Functions
Conditional Formatting:
• Excel - Conditional Formatting
Pivot Tables: • Pivot Tables & its features
#techreflections #conditionalformatting #highlightingcellsonacondition