| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign borders and colors with a condition
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Assign borders and colors with a condition
Use conditional formatting under the Format menu.
-- Regards, Tom Ogilvy wrote in message ps.com... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Assign borders and colors with a condition
Thanks Tom.
Tom Ogilvy wrote: Use conditional formatting under the Format menu. -- Regards, Tom Ogilvy wrote in message ps.com... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Borders Line Colors | Excel Discussion (Misc queries) | |||
| How to assign nothing into a cell under if condition? | Excel Discussion (Misc queries) | |||
| More Concise Way To Assign Borders? | Excel Programming | |||
| Assign auto numbers based on a condition | Excel Worksheet Functions | |||
| Assign ID based on condition(criteria) | Excel Programming | |||
Linear Mode
