FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Option-C is correct that is You can check the conditions against both cell value and formula when applying conditional formatting.

Detailed explanation-2: -They are grouped into three categories: Data Bars are horizontal bars added to each cell, much like a bar graph. Color Scales change the color of each cell based on its value. Each color scale uses a two-or three-color gradient.

Detailed explanation-3: -Conditional Formatting With Multiple Conditions To highlight cells according to multiple conditions being met, you can use the IF and AND Functions within a conditional formatting rule. Select the range you want to apply formatting to. In the Ribbon, select Home > Conditional Formatting > New Rule.

Detailed explanation-4: -To see which cells of a worksheet have conditional formatting rules, possibly to investigate why they aren’t working as you expect, click the Find & Select button on the HOME tab, and then click Conditional Formatting. The cells that have conditional formatting rules are selected.

Detailed explanation-5: -The answer is yes and no. Any conditional formatting argument must generate a TRUE result, meaning that at a literal level, your conditional formatting rule is an If/Then statement along the lines of “If this condition is TRUE, THEN format the cell this way”.