I designed a report in ACC2k7, and set fields for conditional formatting.
Basically if the date in the field is greater than 6 months greater than the date of variable [tierdate], I want the field to appear with a RED background if it is within 6 monhts, I want it to appear GREEN.
I set the conditional format, but when I run the report, the formatting does not show. If I CLICK on the date, it will appear properly (red background), but only if I click on it, not on printed reports, or print preview. I need it to appear on printed reports.
HOWEVER, if I have the condition change the color of the text, it works fine, and the text appears red, green, etc.