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?


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=556424