Conditional Formats in Access

[despatcher]

I am having trouble applying conditional formats to my access db they work in excel but cannot seem to put them in to access I have one table that my forms and queries look at

These are the conditions i had used in excel

formula is =AND($H18>=TODAY(),$H18<TODAY()+14)

this turns red if within two weeks of today

formula is =AND($H18>TODAY()+15,$H18<TODAY()+43)

this turns amber if between two and six weeks of today

less than =<TODAY()

text is struckthrough and turned red

Any help with implementing these in access either similar or new method

 

[KeithG]

You will need to use Date() instead of Today() and then refrence the field instead of a cell.