none
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!

    Thanks,

    Dianne

    Tuesday, October 27, 2015 4:48 PM

Answers

  • 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

    =AND($C2>=TODAY(),$C2<=TODAY()+90)

    Click Format...

    Activate the Fill tab.

    Select a highlight color.

    Click OK twice.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Tuesday, October 27, 2015 7:24 PM