When there is an error in the "EVDRE:OK" cell, I would like to put a message in the header of the report area so that the end user is aware that there is a problem. I would assume that a formula such as
=IF($A$1="EVDRE:OK","","SOME ERROR MESSAGE")
would work. Initially, it appears that this does work. However, the report will no longer refresh and Excel locks up. Has anyone done anything similar to this?
~Alison