hi all,

i need help on:

1) a macro that will automatically fill colour into the cell. Eg: i
cell A1 has the value "Susan" and it will fill the cell with the colou
Blue.

2) a macro that will merge cells of various values together. Eg: cel
B1 holds the value of "high" and cell B2 holds the value of "low" an
if the macro "detects" both of these values.. it will then merge B1 an
B2 together and put a value called "Neutral" into the merged cell.

is it possible to have such macros? pls advise me and if possible can
have the codes please? thanks alot!!! :

--
porki
-----------------------------------------------------------------------
porkie's Profile: http://www.excelforum.com/member.php...fo&userid=1455
View this thread: http://www.excelforum.com/showthread.php?threadid=26190