I want to format cells which START WITH the letter "W", regardless of what else is in the cell.
J Jo Aug 14, 2008 #1 I want to format cells which START WITH the letter "W", regardless of what else is in the cell.
B Barb Reinhardt Aug 14, 2008 #3 In the conditional format formula, put something like this =LEFT(A1,1)="W" Replace A1 with the cell address of interest.
In the conditional format formula, put something like this =LEFT(A1,1)="W" Replace A1 with the cell address of interest.
J Jo Aug 14, 2008 #4 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?
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?
