conditional formatting text

  • Thread starter Thread starter Jo
  • Start date Start date
J

Jo

I want to format cells which START WITH the letter "W", regardless of what
else is in the cell.
 
In the conditional format formula, put something like this

=LEFT(A1,1)="W"

Replace A1 with the cell address of interest.
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
conditional formatting based on the value of another cell 8
Excel Conditional Formatting Removal 7
Excel Conditional Formatting 1
Excel Named Ranges and Conditional Format 3
Excel Macro to automatically go to the right of the last colored cell 0
Conditional Formatting? 4
Negative Conditional Formatting Excel 2003 2

Back
Top