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

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

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

Formatting Via a Macro
 

In cond.format / formula is
=MOD(ROW();2)=1
pick ur color

copy format to all wanted cells