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
|