write the steps for conditional formatting spreadsheet
Answers
Answered by
1
Create conditional formatting rules with formula
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