DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Title
|
|
|
Good
|
|
|
Calculation
|
|
|
Hyperlink
|
Detailed explanation-1: -In our example, we’ll choose Green Fill with Dark Green Text, then click OK. The conditional formatting will be applied to the selected cells.
Detailed explanation-2: -Click Home > Conditional Formatting > Top/Bottom Rules> Top 10 Items. Now set the n value on the window that appears. This will change the color of the top n values in a column. You can change the color of the bottom n values following the same process.
Detailed explanation-3: -Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to. On the Home tab, click Conditional Formatting. Click New Rule. Select a style, for example, 3-Color Scale, select the conditions that you want, and then click OK.
Detailed explanation-4: -On the home tab, in the Styles subgroup, click on Conditional Formatting→New Rule. Now select Use a formula to determine which cells to format option, and in the box type the formula: D3>5; then select Format button to select green as the fill color.