USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
conditional formatting
|
|
cell formatting
|
|
cell styles
|
|
quick access toolbar
|
Detailed explanation-1: -Conditional formatting for empty and non-empty cells Formula for blanks: =$B2="”-format selected cells / rows if a corresponding cell in Column B is blank. Formula for non-blanks: =$B2<>"”-format selected cells / rows if a corresponding cell in Column B is not blank.
Detailed explanation-2: -Conditional formatting allows you to automatically apply formatting-such as colors, icons, and data bars-to one or more cells based on the cell value. To do this, you’ll need to create a conditional formatting rule.
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: -One of the methods to achieve Conditional formatting based on a custom formula is using the IF statement. The IF function works on the IF/THEN/ELSE condition syntax.