I have written VBA to create a conditional formatting rule for a workbook created by an Outputto command in Access. This rule shows up in the list of Conditional Formats for the worksheet, but the background color is not being applied. If anyone can explain why I would be grateful.

Code creating the file (Access 2013):

Please Login or Register  to view this content.
Code creating the conditional format (Excel 2013):

Please Login or Register  to view this content.
Snapshot of the result (Excel 2013), showing cells N8 & N9 without the correct background despite being in the format range:

badformat.JPG