Formatting various cells within an array

[Dennis Reynolds]

I have the general idea on how to do it I just don't know the language for it. I need the borders, indents, font size, and font format to change for various cells. My idea is to create a few format cases and then create a format array with the case names being the entries. Am I on the right path here? My format conditions are below.

With Selection
.IndentLevel = 0
End With
With Selection.Font
.FontStyle = "Standard"
.Size = 10
End With
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Weight = xlHairline
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.Weight = xlHairline
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlHairline
End With

 

[Jaafar Tribak]

I have the general idea on how to do it I just don't know the language for it. I need the borders, indents, font size, and font format to change for various cells. My idea is to create a few format cases and then create a format array with the case names being the entries. Am I on the right path here? My format conditions are below.

I am not sure I understand but I think you should define those formats as custom Styles - Look up the Style/Styles Topic in the help files.

 

[Dennis Reynolds]

I am not sure I understand but I think you should define those formats as custom Styles - Look up the Style/Styles Topic in the help files.

Thank you but I think I found my own way using multiple if or then statements to format the varying cells. Not sure if that's the best way to go about it, but it works anyhow. Thank you for your response though!