I would like to shade cells in my spreadsheet based on information contained
within two date fields:
Column E = Target Date
Column F = Complete Date (left blank until task completed)
Column G = Status (shaded yellow if today's date is equal to col. E and col.
F is null; shaded red if today's date is past col. E and col. F is null;
shaed grey if col. F contains any date (is not null).

Any help would be appreciated.