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