Question

write the different steps to apply conditional formatting??

Answer 1

Hope it will help you...

Answer 2

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 toformat.Under Format values where this formula is true, type the formula: =A2>TODAY() ...Click Format.