|
TODAY formula
Open Close Name
03/06/08 03/07/08 mveach 04/01/08 04/07/08 mveach 04/05/08 05/12/08 mveach 04/14/08 04/18/08 mveach 04/14/08 04/15/08 mveach 04/26/08 04/28/08 mveach 04/27/08 01/00/00 mveach 04/28/08 mveach 04/28/08 mveach 04/28/08 mveach 04/28/08 04/28/08 mveach 04/29/08 05/12/08 mveach 05/09/08 05/13/08 mveach There are three records that are missing a close date... i want to create a formula that says: if a cell is empty then autofill with todays date and fill the cell red( if cell has a close date leave as is). Thanks -- sss |
TODAY formula
Jut put =TODAY() in the cell and then overwrite when you have a date.
-- __________________________________ HTH Bob "sed" wrote in message ... Open Close Name 03/06/08 03/07/08 mveach 04/01/08 04/07/08 mveach 04/05/08 05/12/08 mveach 04/14/08 04/18/08 mveach 04/14/08 04/15/08 mveach 04/26/08 04/28/08 mveach 04/27/08 01/00/00 mveach 04/28/08 mveach 04/28/08 mveach 04/28/08 mveach 04/28/08 04/28/08 mveach 04/29/08 05/12/08 mveach 05/09/08 05/13/08 mveach There are three records that are missing a close date... i want to create a formula that says: if a cell is empty then autofill with todays date and fill the cell red( if cell has a close date leave as is). Thanks -- sss |
TODAY formula
is there any conditioning I can do so that if they are empty they can
autoamitically turn into todays date and fill up with a red color so I can know they were the ones that were empty to begin with? Thank you -- sss "Bob Phillips" wrote: Jut put =TODAY() in the cell and then overwrite when you have a date. -- __________________________________ HTH Bob "sed" wrote in message ... Open Close Name 03/06/08 03/07/08 mveach 04/01/08 04/07/08 mveach 04/05/08 05/12/08 mveach 04/14/08 04/18/08 mveach 04/14/08 04/15/08 mveach 04/26/08 04/28/08 mveach 04/27/08 01/00/00 mveach 04/28/08 mveach 04/28/08 mveach 04/28/08 mveach 04/28/08 04/28/08 mveach 04/29/08 05/12/08 mveach 05/09/08 05/13/08 mveach There are three records that are missing a close date... i want to create a formula that says: if a cell is empty then autofill with todays date and fill the cell red( if cell has a close date leave as is). Thanks -- sss |
| All times are GMT +1. The time now is 06:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com