View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jo Jo is offline
external usenet poster
 
Posts: 113
Default conditional formatting text

Thank you Peo.

I entered it in conditional formatting but it didn't work. I tried both the
'cell value' and 'formula' options. How can I apply it?

"Peo Sjoblom" wrote:

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.