Question

write steps to perform conditional formatting using Hightlight cells rules option​

Answer 1

Answer:

o 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.: