Hi all,

In row 2 I have dates, E2 contains April 4 2005, F2 April 5 2005, G2 April 6
2005 etc.
In A4 to A40 I have names and in E4 to CR40 I have an entry where an
appointment is made. For instance, in A7 I have "Maas" and I have an
appointment with Maas at April 6, then in G7 will be a non numerical entry
(for instance "H 14.00 London" or some other text).

In the row of each name there should be an appointment for today or any
future date, that is what I want to check.

If a name has no appointment for "today" (I mean the day I am looking to the
spread sheet) nor for any later date, I want to put the name in red and bold
by means of conditional formatting. What conditional formatting formula do I
have to use for A4 to A40?

Jack Sons
The Netherlands