S
Saltrams
Looks easy doesn't it? Hah!
Any instructions as to how I can do the following:
Column M cells are already formatted to show the date as (in the cas
of M2 for example) =A2+28 (so, 28 days after the date that is entere
into A2). I want the date that is calculated & shown in M2 to turn re
7 days before that date. If the date in A2 is 01/06/04 then M2 wil
read 29/06/04 but I want it to turn red on 22/06/04 (I use dd/mm/yy a
I'm in Europe) and then I want it to turn bold red two days before th
date - in this example 27/06/04.
I also need a similar effect to make the date generated in column
turn red if the date today is more than 29 days after the date entere
in column A. The cells are already formatted to generate a date that i
28 days later than that entered in A, using =A2+28 again.
Here's hoping someone knows and is willing to share......
Any instructions as to how I can do the following:
Column M cells are already formatted to show the date as (in the cas
of M2 for example) =A2+28 (so, 28 days after the date that is entere
into A2). I want the date that is calculated & shown in M2 to turn re
7 days before that date. If the date in A2 is 01/06/04 then M2 wil
read 29/06/04 but I want it to turn red on 22/06/04 (I use dd/mm/yy a
I'm in Europe) and then I want it to turn bold red two days before th
date - in this example 27/06/04.
I also need a similar effect to make the date generated in column
turn red if the date today is more than 29 days after the date entere
in column A. The cells are already formatted to generate a date that i
28 days later than that entered in A, using =A2+28 again.
Here's hoping someone knows and is willing to share......