Apply bold/italics based on content of a cell

[divinefishi]

Hi,

I am trying to bold/italic a cell based on its content.

I have A1:A50 populated as shown below(some cells begin with numbers and some begin with text), i would like to italicize all the cells in the column that begins with text AND bold all the cells that begin with the word "Total"

here is a data sample(with the desired formatting manually applied, however i have to create 100 of these templates so a macro/formula solution would be greatly appreciated):

<TABLE style="WIDTH: 290pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=387 border=0><COLGROUP><COL style="WIDTH: 290pt; mso-width-source: userset; mso-width-alt: 14153" width=387><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 290pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=387 height=20>66010200 DIRECT LABOR</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>66010400 DIRECT LABOR COSTS</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>66010500 DIRECT LABOR -EXEMPT</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>PAYROLL & BURDEN EXPENSE</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>68720000 EMPL COSTS-PERSONAL & BUSINESS EXP - 100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>68730000 50% DEDUCTIBLE MEALS & ENT.</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>TRAVEL EXPENSE</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>66070000 EMPLOYEE BONUS/COMMISSION - VARIABLE PAY</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>OTHER EMPLOYEE EXPENSE</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>TOTAL EMPLOYEE EXPENSE</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>71900000 EQUIP MATERIALS & SUPPLIES:GENERAL</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>71900300 OTHER EQUIP MAT SUPP:COMPUTER HARDWARE</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>71900400 OFFICE STATIONARY & SUPPLIES</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>OTHER MATERIALS & SUPPLIES EXPENSE</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>TOTAL MATERIALS & SUPPLIES EXPENSE</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>70003500 OPERATING EXPENSE:CONTRACT LABOR-GENERAL</TD></TR></TBODY></TABLE>

thanks so much!

 

[Jonmo1]

Welcome to the board..

Conditional formatting will do that for you.

Steps may vary depending on version of Excel..
In XL2003..

Highlight Range A1:A50
Click Format - Conditional Formatting

Condition1:
Select Formula Is
Enter the formula
=LEFT(A1,5)="Total"
Click Format
Apply Bold Italic Font
Click OK

Condition 2:
Select formula Is
Enter the formula
=ISERROR(LEFT(A1,1)+0)
Click Format
Apply Italic Font
Click OK
Click OK


Hope that helps

Sheet1

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 405px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD>66010200 DIRECT LABOR</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD>66010400 DIRECT LABOR COSTS</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD>66010500 DIRECT LABOR -EXEMPT</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-STYLE: italic">PAYROLL & BURDEN EXPENSE</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD>68720000 EMPL COSTS-PERSONAL & BUSINESS EXP - 100</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD>68730000 50% DEDUCTIBLE MEALS & ENT.</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-STYLE: italic">TRAVEL EXPENSE</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD>66070000 EMPLOYEE BONUS/COMMISSION - VARIABLE PAY</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-STYLE: italic">OTHER EMPLOYEE EXPENSE</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-WEIGHT: bold; FONT-STYLE: italic">TOTAL EMPLOYEE EXPENSE</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD>71900000 EQUIP MATERIALS & SUPPLIES:GENERAL</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD>71900300 OTHER EQUIP MAT SUPP:COMPUTER HARDWARE</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD>71900400 OFFICE STATIONARY & SUPPLIES</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-STYLE: italic">OTHER MATERIALS & SUPPLIES EXPENSE</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-WEIGHT: bold; FONT-STYLE: italic">TOTAL MATERIALS & SUPPLIES EXPENSE</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD>70003500 OPERATING EXPENSE:CONTRACT LABOR-GENERAL</TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #ff0000; BORDER-BOTTOM-COLOR: #ff0000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #ff0000; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #ff0000; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Conditional formatting </TD></TR><TR><TD><TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=0 border=1><TBODY><TR><TD>Cell</TD><TD>Nr.: / Condition</TD><TD>Format</TD></TR><TR><TD>A1</TD><TD>1. / Formula is =LEFT(A1,5)="Total"</TD><TD style="FONT-WEIGHT: bold; FONT-STYLE: italic">Abc</TD></TR><TR><TD>A1</TD><TD>2. / Formula is =ISERROR(LEFT(A1,1)+0)</TD><TD style="FONT-WEIGHT: bold; FONT-STYLE: italic">Abc</TD></TR><TR><TD>A2</TD><TD>1. / Formula is =LEFT(A2,5)="Total"</TD><TD style="FONT-WEIGHT: bold; FONT-STYLE: italic">Abc</TD></TR><TR><TD>A2</TD><TD>2. / Formula is =ISERROR(LEFT(A2,1)+0)</TD><TD style="FONT-WEIGHT: bold; FONT-STYLE: italic">Abc</TD></TR><TR><TD>A3</TD><TD>1. / Formula is =LEFT(A3,5)="Total"</TD><TD style="FONT-WEIGHT: bold; FONT-STYLE: italic">Abc</TD></TR><TR><TD>A3</TD><TD>2. / Formula is =ISERROR(LEFT(A3,1)+0)</TD><TD style="FONT-WEIGHT: bold; FONT-STYLE: italic">Abc</TD></TR><TR><TD>A4</TD><TD>1. / Formula is =LEFT(A4,5)="Total"</TD><TD style="FONT-WEIGHT: bold; FONT-STYLE: italic">Abc</TD></TR><TR><TD>A4</TD><TD>2. / Formula is =ISERROR(LEFT(A4,1)+0)</TD><TD style="FONT-WEIGHT: bold; FONT-STYLE: italic">Abc</TD></TR><TR><TD>A5</TD><TD>1. / Formula is =LEFT(A5,5)="Total"</TD><TD style="FONT-WEIGHT: bold; FONT-STYLE: italic">Abc</TD></TR><TR><TD>A5</TD><TD>2. / Formula is =ISERROR(LEFT(A5,1)+0)</TD><TD style="FONT-WEIGHT: bold; FONT-STYLE: italic">Abc</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

 

[VoG]

Try CF formula

=OR(ISNUMBER(--LEFT(A1,1)),LEFT(A1,5)="Total")

 

[divinefishi]

wow that was so fast. works perfectly thanks so much!!