Match date problem
 

Hi!
I have a table with some kind of calendar, i.e.
Jan - 1 2 3 4 5 6 7 8 F F F F F F 15 16 17 18 ... 2007
Feb - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17... 2007
Mar - ....
Apr - ....
May - 1 2 3 4 M M M M 9 10 11 12 13... 2007

I want to have a cell in wich ill have a warning like "near Vacancies" that
appears on 5 days before vacancies (M). Can someone help me?
Thanks

Match date problem
 

In row 1, starting at A1, I entered 1,2,3,4,5,6, m
I selected the row; use Format|Conditional Formatting
Use Formula Is =OFFSET(A1,0,5)="M" and set font colour to red
The cell (C1) shows in red since five cells along there is an M
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Micos3" wrote in message
...
Hi!
I have a table with some kind of calendar, i.e.
Jan - 1 2 3 4 5 6 7 8 F F F F F F 15 16 17 18 ... 2007
Feb - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17... 2007
Mar - ....
Apr - ....
May - 1 2 3 4 M M M M 9 10 11 12 13... 2007

I want to have a cell in wich ill have a warning like "near Vacancies"
that
appears on 5 days before vacancies (M). Can someone help me?
Thanks

Match date problem
 

Maby some like cont.format
put this formula in cont.formating in the cell where u have JAN 1
i ges its B2 or else change formula

=AND(DATE(2007,ROW(1:1),COLUMN())<=(NOW()+5),B2="M ")

make ur choice of formatcolor

copy this cell to ur matrix (u have to copy) copy format dont work
then insert 1234... and MMM again


"Micos3" skrev:

Hi!
I have a table with some kind of calendar, i.e.
Jan - 1 2 3 4 5 6 7 8 F F F F F F 15 16 17 18 ... 2007
Feb - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17... 2007
Mar - ....
Apr - ....
May - 1 2 3 4 M M M M 9 10 11 12 13... 2007

I want to have a cell in wich ill have a warning like "near Vacancies" that
appears on 5 days before vacancies (M). Can someone help me?
Thanks

Match date problem
 

I can't try your solution now but ill surelly try tomorrow and then aftr i'll
get some feedback.
Thanks

"excelent" wrote:

Maby some like cont.format
put this formula in cont.formating in the cell where u have JAN 1
i ges its B2 or else change formula

=AND(DATE(2007,ROW(1:1),COLUMN())<=(NOW()+5),B2="M ")

make ur choice of formatcolor

copy this cell to ur matrix (u have to copy) copy format dont work
then insert 1234... and MMM again


"Micos3" skrev:

Hi!
I have a table with some kind of calendar, i.e.
Jan - 1 2 3 4 5 6 7 8 F F F F F F 15 16 17 18 ... 2007
Feb - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17... 2007
Mar - ....
Apr - ....
May - 1 2 3 4 M M M M 9 10 11 12 13... 2007

I want to have a cell in wich ill have a warning like "near Vacancies" that
appears on 5 days before vacancies (M). Can someone help me?
Thanks