Conditional Formatting & VBA Code

I think he means to use the same test that the conditional formatting uses.
For example, if the conditional formatting turns a cell Red when the number is negative, then you test the cell contents for negative numbers before allowing a save.