change font color for cells starting with "T "
 

Hi guys,

I have multiple columns of data in which there are many occurences of a
certain object. These values start with "T" and then there's a space and then
a code/ date [looks something like T APR01/07, or T 09102007].

I was wondering if someone could help me with a macro that changes the font
color for the columns between H and AG for cells starting with T and space,
and change the color of the values to teal (plus bold it). I tried
conditional formatting, but it doesn't have anything for cells beginning with
a certain value.

Thanks,

Pman.

change font color for cells starting with "T "
 

You can use Conditional Formatting, say in A1:

Formula Is:

=LEFT(A1,2)="T "

and then set your desired formats
--
Gary''s Student - gsnu200750


"Pman" wrote:

Hi guys,

I have multiple columns of data in which there are many occurences of a
certain object. These values start with "T" and then there's a space and then
a code/ date [looks something like T APR01/07, or T 09102007].

I was wondering if someone could help me with a macro that changes the font
color for the columns between H and AG for cells starting with T and space,
and change the color of the values to teal (plus bold it). I tried
conditional formatting, but it doesn't have anything for cells beginning with
a certain value.

Thanks,

Pman.

change font color for cells starting with "T "
 

Gary''s Student wrote:
You can use Conditional Formatting, say in A1:

Formula Is:

=LEFT(A1,2)="T "

and then set your desired formats

Or, if some cells'value may be t

=EXACT(LEFT(F8,1),"T")

Alan Beban

change font color for cells starting with "T "
 

Thanks Guys :)

Was able to do it with a macro :)

Columns("H:AF").Select
With Application.ReplaceFormat.Font
.FontStyle = "Bold"
.Subscript = False
.ColorIndex = 13
End With
Selection.Replace What:="T *", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=True

Thanks again :)

"Alan Beban" wrote:

Gary''s Student wrote:
You can use Conditional Formatting, say in A1:

Formula Is:

=LEFT(A1,2)="T "

and then set your desired formats

Or, if some cells'value may be t

=EXACT(LEFT(F8,1),"T")

Alan Beban