Conditional Formatting

I have designed a report that includes Names and Dates of Death.

I would like the font color for those that died in the 19th century to be
red and those that died in the 20th century to be in blue.

I have managed to get the right colors for the Date of Death using the
Conditional formatting. The problem is that the names all appear in black.
I have attempted to use the Conditional formatting for the Names field using
the following 2 conditions and selecting the appropriate font color:

Condition 1 Expression is: [Date of Death] between 01/01/1900 and 01/01/2000
Condition 2 Expression is: [Date of Death] between 01/01/2001 and 01/01/3000

I would appreciate any guidance to where I have gone wrong and Many thanks

Try surrounding the dates in the expression with # signs to signify they are
dates and not division expressions.

Condition 1 Expression is: [Date of Death] between #01/01/1900# and #01/01/2000#
Condition 2 Expression is: [Date of Death] between #01/01/2001# and #01/01/3000#


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Roger Bell wrote:
I have designed a report that includes Names and Dates of Death.

I would like the font color for those that died in the 19th century to be
red and those that died in the 20th century to be in blue.

I have managed to get the right colors for the Date of Death using the
Conditional formatting. The problem is that the names all appear in black.
I have attempted to use the Conditional formatting for the Names field using
the following 2 conditions and selecting the appropriate font color:

Condition 1 Expression is: [Date of Death] between 01/01/1900 and 01/01/2000
Condition 2 Expression is: [Date of Death] between 01/01/2001 and 01/01/3000

I would appreciate any guidance to where I have gone wrong and Many thanks