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
全站熱搜