Microsoft Access 2010 Export To Excel Conditional Formatting

I have a query qryforrecordexcel. I have code that creates an excel spreadsheet at a set time everyday from the query. In the query the status can be open or closed. If it is closed the row background should be light gray. If it is open and the request has been responded to"Response Date" (a date field) the row background should be blue.  There are multiple fields. How do I accomplish this? Please be as specific as possible as to where I should put the code. Thanks for the help.