Change dates to a formula
Select the cells where you want the conditional format, then click on
Format, Conditional Formatting, write required dates in From and To
boxes, define the Format, and then click Add,
Add second condition values for green background required, and click
okay.
Aqib Rizvi
|