FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -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.

Detailed explanation-2: -Conditional formatting is used to format a cell or a range of cells based on specified criteria. In one report, you can create as many conditions as you need and each condition can apply different formatting rules.

Detailed explanation-3: -Conditional formatting is a feature of many spreadsheet applications that allows you to apply special formatting to cells that meet certain criteria. It is most often used to highlight, emphasize, or differentiate among data and information stored in a spreadsheet.

Detailed explanation-4: -You can set up conditional formatting that checks the value in one cell, and applies formatting to other cells, based on that value. For example, if the values in column B are greater than 75, make all data cells in the same row blue. The video and notes below show you the easy steps.

Detailed explanation-5: -Video: Use 2 Rules to Format Cells There will be 2 conditional formatting rules for the selected cells: turn green if it contains a value higher than 75. turn red if it contains a value lower than 50.