Conditional formating

[prabhus]

In my Access forms, i display data by month wise; and i want to give the conditional formating with two condition;
If date of today is greater than target date for that month and if got value more than 0 - Red color
If date of today is lesser than target date for that month and if got value more than 0 - green color
Target date for every month in available in a separate table.
how to do this?

 

[jdraw]

cross posted at http://www.utteraccess.com/forum/Conditional-Formating-t2021596.html&gopid=2486553#entry2486553

What have you tried? What results?