close

I need to flag either a cell or a cell next to it to fill with a color when
the original cell date has passed a set number of days, i.e., original cell
is 1/3/06, flag date would be 7 days out.


Use Conditional Formatting

In the cell containing the date, for the condition use:
Cell value is - less than - =TODAY()-6

Apply your formatting--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=512768

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()