Cell Styles & Conditional Formatting in excel(Cell value,Date value,Data bars,Color scale,Icon set)

A cell style is a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading. To prevent anyone from making changes to specific cells, you can also use a cell style that locks cells.
Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition. You can manage all aspects of conditional formatting—creating, editing, and deleting rules—in one place using the Rules Manager.
In this video, we will explore how to use Conditional formatting for Cell values, Date Values. How to use Data bars, Color scale and Ion sets.
00:00:00 Cell styles
00:07:20 Conditional formatting (cell values)
00:11:14 Conditional formatting (date values)
00:16:35 Conditional formatting (data bars)
00:20:55 Conditional formatting (color scale)
00:23:12 Conditional formatting (icon sets)