View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Pman Pman is offline
external usenet poster
 
Posts: 36
Default 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