Access 2007 - Conditional Formatting
Posted on 2011-02-16
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