R
Roger Bell
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
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