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.

You need to set up conditional formatting for the cells.

Select the first cell in column G that you wish to control. Goto to the
menu item Format and choose Conditional Formatting.

In the left hand box condition 1, select 'Formula Is' , in the box next to
the right type in =AND($E4=TODAY(),$F4=0)
(Note: I have chosen row 4 above, change to suit your first row); then in
click the Format option and set the Pattern to Yellow.

Click Add>> and in condition 2 set 'Formula Is' and enter in box
=AND(($E4<TODAY(),$F4=0)
Set pattern to Red.

Click Add>> and in condition 3 set 'Formula Is' and enter in box =F8>0
Set pattern to Grey.

Press OK and copy the cell down to all rows to be monitored.


--

Regards,
Nigel
(E-Mail Removed)



"Ann" <(E-Mail Removed)> wrote in message
news:A7FA4DD0-E97D-4612-B31D-(E-Mail Removed)...
>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.