Conditional formatting to highlight cells
Answers
Answered by
2
hey mate...
To create the first rule:
- Select cells A2 through A7. ...
- Then, click Home > Conditional Formatting > New Rule.
- In the New Formatting Rule dialog box, click Use a formula to determine which cells to format.
- Under Format values where this formula is true, type the formula: =A2>TODAY() ...
- Click Format.
Similar questions