ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I flag a cell in Excel 2002 when the date entered has pass (https://www.excelbanter.com/excel-discussion-misc-queries/71801-how-do-i-flag-cell-excel-2002-when-date-entered-has-pass.html)

sas1950

How do I flag a cell in Excel 2002 when the date entered has pass
 
I want to either flag the cell or the one next to it to fill with a color
when the original cell has passed a given number of days, i.e., original date
is 1/3/06, flag date would be 7 days out.


All times are GMT +1. The time now is 08:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com