to highlight the field with condition, your only choice is using form Datasheet.
if you have everything you need on table/query, just wanna hightlight them up.
In Access 2010 (2007 somewhat similar), choose the table (dont open it) then go to CREATE section in ribbon, point to more form and choose Datasheet form from droplist.
ok, Access will open your table in Datasheet form. Next, select your collumn that you want to apply conditions, right click on it's title -> select conditional formating at the end of droplist.
now you can set whatever condition you want and choose highlight style you need.