![]() Excel displays the New Formatting Rule dialog box. The Conditional Formatting Rules Manager dialog box. Excel displays the Conditional Formatting Rules Manager dialog box. Excel displays a palette of options related to conditional formatting. With the Home tab of the ribbon displayed, click the Conditional Formatting option in the Styles group.For instance, let's assume that you want to apply the conditional formatting to cell A1. You can achieve this type of conditional formatting if you apply a formula. ![]() For his purposes he wanted a cell to be red if it contains today's date, to be yellow if it contains a date within a week of today, and to be green if it contains a date within two weeks. Richard wondered if it was possible, using conditional formatting, to change the color of a cell.
0 Comments
Leave a Reply. |