77-427 Exam Dumps | Apply conditional formatting using a formula. Cell range B5:I299 Apply if "Date" (column D) is a Saturday

Valid 77-427 Dumps shared by ExamDiscuss.com for Helping Passing 77-427 Exam! ExamDiscuss.com now offer the newest 77-427 exam dumps, the ExamDiscuss.com 77-427 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 77-427 dumps with Test Engine here:

Access 77-427 Dumps Premium Version
(62 Q&As Dumps, 35%OFF Special Discount Code: freecram)

<< Prev Question Next Question >>

Question 5/12

Apply conditional formatting using a formula.
Cell range B5:I299
Apply if "Date" (column D) is a Saturday or Sunday
Function WEEKDAY (return MONDAY as 0)
Formatting Bold and Single Underline

Correct Answer:

Use the following steps in explanation.
Explanation/Reference:
Explanation:
Step 1: In the name box type B5:I299 (or Click cell B5, shift-click cell I299).

Step 2: On the Home tab, select Conditional Formatting, and click New Rule

Step 3: In The Edit Formatting Rule dialog box select Use a formula to determine which cells to format, type the formula: =WEEKDAY($D5,2)>5, and click the Format button.