Query on Conditional Formatting / Message Box

[Roopen]

Hi All,

Maybe a long shot but I might as well ask... is there a way of having a message box appear when someone closes my workbook with any conditional formats triggered to colour the cells in red..

For example if cell A1 is red due to conditional formatting being triggered can I remind the user to check it before they save/close?

Any help as always appreciated

 

[Roopen]

I have just tried it and works exactly how I wanted it to... Thank you once again for your help and patience..