fill cells, merge cells
 

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

fill cells, merge cells
 

Hi
1. Why use a macro. I would use 'Format - Conditional format' for thius
2. How will you identify which cells should be merged. Do you want to
select them first? Also what are the rules for 'merging' and creating
the new value

--
Regards
Frank Kabel
Frankfurt, Germany


porkie wrote:
hi all,

i need help on:

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

2) a macro that will merge cells of various values together. Eg: cell
B1 holds the value of "high" and cell B2 holds the value of "low" and
if the macro "detects" both of these values.. it will then merge B1
and 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
i have the codes please? thanks alot!!! :)