Macro help, again!
 

Hi,

Im continuing on with my "highlighting" macro as per my post yesterday
(thanks for the advice guys), but as always I now want to expand what it
does...unfortunately my code doesnt do what its meant too!

What I would like would be if cell c12 is "ms" then cell h12 would have a
border AND cells h9 and h10 would have a border, have a grey background and
the text in them would become black. When I do this I can get the either
the 1st or the 2nd part working, but not both simultaneously.

Also, is there a way that would mean that i didt have to specify a cell for
the value to be "ms" - im going to be entering data in c11 down to c40 and
would want the macro to highlight the cells in the correspoding row.

Thanks in advance,

Matt

Macro help, again!
 

Rather than a macro, perhaps the Format, Conditional Formatting
approach might work in a simpler way here. Use the "Formula Is"
rather than the "Cell Value Is" option. If you do this, set the
formats you described in cells H12, H9 and H10, but have the
Conditional Formatting work to make them "plain" when cell C12 is NOT
"ms".

"Matt B" wrote in message ...
Hi,

Im continuing on with my "highlighting" macro as per my post yesterday
(thanks for the advice guys), but as always I now want to expand what it
does...unfortunately my code doesnt do what its meant too!

What I would like would be if cell c12 is "ms" then cell h12 would have a
border AND cells h9 and h10 would have a border, have a grey background and
the text in them would become black. When I do this I can get the either
the 1st or the 2nd part working, but not both simultaneously.

Also, is there a way that would mean that i didt have to specify a cell for
the value to be "ms" - im going to be entering data in c11 down to c40 and
would want the macro to highlight the cells in the correspoding row.

Thanks in advance,

Matt