ExcelBanter - Assign borders and colors with a condition

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Assign borders and colors with a condition (https://www.excelbanter.com/excel-programming/379967-assign-borders-colors-condition.html)

[email protected]

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

Tom Ogilvy

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

[email protected]

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

All times are GMT +1. The time now is 05:11 PM.