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 one of the most simple yet powerful features in Excel Spreadsheets. As the name suggests, you can use conditional formatting in Excel when you want to highlight cells that meet a specified condition. It gives you the ability to quickly add a visual analysis layer over your data set.

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

Detailed explanation-5: -Go to Conditional Formatting>Manage Rules. What is this? Click the New Rule button in the rules manager and from the list of conditions, select ‘Format only cells that contain’ and select ‘Blank’ under the ‘Format only cells with’ dropdown. Click OK.