Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |