Changing the colour of a cell (or any formatting change) does not fire a
change event so what you are asking for is quite difficult to achieve in real
time. You need to control access to the colour pallet via code and then check
the colour. This is not too bad to do via a command button but if the user
uses any of the standard methods of colouring then the code does not run.
--
HTH...

Jim Thomlinson


"Jeremy" wrote:

I am using a color function =ColorFunction(A2,A9;AA9). Is there a way to
write a script or something like to where if the wrong color is selected you
could get a warning message or a message that states are you sure you want to
use this color?

Thank you