Frode,
The formula for the cell in which you want the current date to be inserted is:
=IF(A1="","",NOW())
You will need to format the result to be a DATE format. Choose
Format>Cells, and then choose DATE. Select the DATE format option that you
want to apply.
Conditional Formatting will allow you to achieve cell colors, text colors,
and other cell formating options based on a value in an adjacent cell.
1) Select the cell to which you want to apply conditional formating;
2) Choose Format>Conditional Formating. The conditional formating dialogue
box will appear.
3) In the 1st drop down list, select "Cell Value Is", then
4) In the 2nd drop down list, select "not equal to", then
4) In the 3rd drop down list, enter ="""""", then
5) click on the Format button. The Format Cells dialogue box will appear.
6) Click on the Patters tab, and select the color you want to apply. Click
OK to close the Format Cells dialogue box. Then Click on OK in the
Conditional Formating dialogue box to close that box.
Let me know if this resolves your questions. Hope this does the trick for
you.
Best Wishes, Mike