Thread: change font color for cells starting with "T "
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_2_] Alan Beban[_2_] is offline
external usenet poster
  
Posts: 783
Default 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
Reply With QuoteReply With Quote