View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default conditional formatting text

In the conditional format formula, put something like this

=LEFT(A1,1)="W"

Replace A1 with the cell address of interest.
--
HTH,
Barb Reinhardt



"Jo" wrote:

I want to format cells which START WITH the letter "W", regardless of what
else is in the cell.