Question

what are the steps to apply conditional formatting?​

Answer 1

Answer:

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.

hope its helpful