Link to home
Create AccountLog in
Avatar of JosephEricDavis
JosephEricDavis

asked on

Access 2007 - Conditional Formatting

I've got a report that displays a number of rows of data with multiple data items per row.

I need to apply conditional formatting to a row that will change the forecolor of the row to red if the end date is within 6 months of the current date.

I have found the place in Access where you configure the conditional formatting and I can tell that need to use the 'Expression Is' condition, but I'm not sure how to build my expression in order to get my desired result.

Thanks for help
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account