Hi,

Am Sun, 4 May 2014 11:32:09 +0100 schrieb slipper:


Out of
interest is there a way to assign a colour to the cell depending on what
message shows?

for example something like

your RAND formula in A1. Then:

=CHOOSE(A1,"MessageA (CELL green)","MessageB (CELL blue)","MessageC
(CELL red)","MessageD (CELL yellow)","MessageE (CELL
orange)",.........)

look for Conditional Formatting


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional