90 days or less RRS feed

  • Question

  • I can't figure out the formula to change cell color on items that are coming up for renewal that are 90 days or less...Please help!



    Tuesday, October 27, 2015 4:48 PM


  • Let's say the renewal dates are in C2:C100.

    Select this range; I'll assume that C2 is the active cell within the selection.

    On the Home tab of the ribbon, click Conditional Formatting > New Rule...

    Select 'Use a formula to determine which cells to format'.

    Enter the formula


    Click Format...

    Activate the Fill tab.

    Select a highlight color.

    Click OK twice.

    Regards, Hans Vogelaar (

    Tuesday, October 27, 2015 7:24 PM