Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting Via a Macro
Is it possible to format sheets (visualize an inventory sheet with white row - grey row - white row - grey row) via macros? I currently have the sheets set up so that people can just type in what they need. However, often people will cut/copy/paste/drag/fill down, etc and it messes up the formatting I have on the sheet. Is there a way to set the colors & borders via a macro? -- wilro85 ------------------------------------------------------------------------ wilro85's Profile: http://www.excelforum.com/member.php...o&userid=26935 View this thread: http://www.excelforum.com/showthread...hreadid=572760 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting Via a Macro
You can do that with macro's however I would recommend conditional
formatting. Select all cells Go To: Format Menu... Conditional Formating... Click "Cell Value Is" and Change to "Formula Is" Type this for the formula: =MOD(ROW(),2) = 0 Click "Format..." Click the "Patterns" Tab Select new background tab Click ok twice Charles wilro85 wrote: Is it possible to format sheets (visualize an inventory sheet with white row - grey row - white row - grey row) via macros? I currently have the sheets set up so that people can just type in what they need. However, often people will cut/copy/paste/drag/fill down, etc and it messes up the formatting I have on the sheet. Is there a way to set the colors & borders via a macro? -- wilro85 ------------------------------------------------------------------------ wilro85's Profile: http://www.excelforum.com/member.php...o&userid=26935 View this thread: http://www.excelforum.com/showthread...hreadid=572760 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting Via a Macro
Use conditional formatting with a formula of
=MOD(ROW(),2)=0 then it adjusts automatically. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "wilro85" wrote in message ... Is it possible to format sheets (visualize an inventory sheet with white row - grey row - white row - grey row) via macros? I currently have the sheets set up so that people can just type in what they need. However, often people will cut/copy/paste/drag/fill down, etc and it messes up the formatting I have on the sheet. Is there a way to set the colors & borders via a macro? -- wilro85 ------------------------------------------------------------------------ wilro85's Profile: http://www.excelforum.com/member.php...o&userid=26935 View this thread: http://www.excelforum.com/showthread...hreadid=572760 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting Via a Macro
In cond.format / formula is
=MOD(ROW();2)=1 pick ur color copy format to all wanted cells |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Formatting? Please Help | Excel Programming | |||
Macro Formatting? Please Help | Excel Programming | |||
macro for formatting | Excel Programming | |||
formatting macro | Excel Programming | |||
Macro for formatting | Excel Programming |