OK, so heres one for you all, I have an indicator cell with conditional formatting, so depending on other conditions it is red, amber or green.

I also have a button that runs a macro, if you click this button when the cell is red, I need an error message to come up with something like "Insufficient information entered", and then drop out of the macro.

If the cell is amber when the macro is run, I need a warning message to come up saying "Incomplete information, continue?" and then an option to drop out of the macro back to excel, or continue anyway.

If the cell is green I need the macro to run as normal.

Any ideas?