It might work in Report view, but the format events don't fire. You can try the paint event instead, but that's untested. I've done some VBA-based conditional formatting in report view and it worked in the paint event.