Conditional statements
If a cell has a specific value I want to format another cell for them to
enter a date. If it has a differnt value, I would like to automatically fill
in n/a for the date. For instance if their answer is Y then I want a date
format for the cell, if the answer is N then I want N/A to automatically be
put into the cell.
|