Conditional formatting based on dates
 

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.

Conditional formatting based on dates
 

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 =F80
Set pattern to Grey.

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


--

Regards,
Nigel




"Ann" wrote in message
...
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.