TODAY formula

[sed]

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

 

[Bob Phillips]

Jut put =TODAY() in the cell and then overwrite when you have a date.

 

[sed]

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