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.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit