| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Problem | Excel Discussion (Misc queries) | |||
| How can I match a calculated date to closest date from a list? | Excel Worksheet Functions | |||
| MATCH function problem | Excel Discussion (Misc queries) | |||
| match problem | Excel Worksheet Functions | |||
| problem with =isnumber(match(right(... | Excel Worksheet Functions | |||
Hybrid Mode
