View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default conditional formatting text

Use formula is and

=LEFT(TRIM(A1))="W"


--


Regards,


Peo Sjoblom



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