Microsoft Excel 2013 Expert Part 1 Questions and Answers
Question 1
Conditional Formatting.
Use a formula to determine formatting of a cell.
Cell I3
Apply formatting if cell is more than three days prior to current date
Use Function TODAY()
Format with Custom solid fill color (RGB – R:255 G:59 B:59)
Options:
Answer:
Answer:
Use the following steps in explanation.
Explanation:
Explanation:
Step 1:Click cell I3.
Step 2:In the Home tab, click Conditional Formatting, and select New Rule.
Step 3:In the New Formatting Rule dialog box select Use a formula to determine which cells to format, in the Formal Values where this formula is true type:=TODAY()-I3>3, and then click the Format button.
Step 4:In the Format Cells dialog box click the Fill tab, click More Colors, in the Colors Dialog box click the Custom tab, change Green to 59, change Blue to 59, click OK, click OK, and finally click OK in the New Formatting Rule dialog box.