Assign borders and colors with a condition

's Computer Specifications

Can anyone suggest a macro to assign borders and border colors for a
range in Sheet1 if the value of cell A1=1? Thanks. Michael

's Computer Specifications

Use conditional formatting under the Format menu.

--
Regards,
Tom Ogilvy

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Can anyone suggest a macro to assign borders and border colors for a
> range in Sheet1 if the value of cell A1=1? Thanks. Michael
>

's Computer Specifications

Thanks Tom.

Tom Ogilvy wrote:
> Use conditional formatting under the Format menu.
>
> --
> Regards,
> Tom Ogilvy
>
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Can anyone suggest a macro to assign borders and border colors for a
> > range in Sheet1 if the value of cell A1=1? Thanks. Michael
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Borders Line Colors	julesjules2	Microsoft Excel Misc	2	26th Mar 2010 01:22 PM
How to assign nothing into a cell under if condition?	=?Utf-8?B?RXJpYw==?=	Microsoft Excel Misc	7	1st Jun 2007 01:17 PM
More Concise Way To Assign Borders?	(PeteCresswell)	Microsoft Excel Programming	4	22nd Dec 2006 10:43 AM
Setting colors/borders for cell	k483	Microsoft Excel Misc	2	1st Nov 2004 08:57 PM
Colors don't appear in shared borders	Jeremy	Microsoft Frontpage	3	12th Apr 2004 09:09 PM