Select the cells to which you want to apply conditional formatting.2. Click the Quick Analysis tool button at the lower right corner of the selection.3. Notice that Live Preview displays the effect of the conditional formatting on your data as you hover the mouse pointer over each of the formatting options. Review each formatting option before making your selection.4. Click the button for the type of conditional formatting you want to apply.