Hi,

Ive just started to use macros and I would appreciate any help on the
following ideas!

1) Is it possible to have a macro "always" running...so for example
if i entered data in one cell it would automatically format/copy/etc
into another cell.

2)And secondly, is it possible to say, fill cells with a colour
dependant upon the data entered in anothercell . eg:

if a1="Mr"(or active cell=1) then cells a3 a4 and a5 would fill in
orange.
if a1="Mrs" then cells a3 a4 and a5 would fill red.

Thanks in advance for the help.

Matt