Conditional Formatting

[Mister H]

Hi All:

I am trying to set up Conditional Formatting in cell A10 so that if the first 20 letters in Cell A10 = Returned to sender o then make the font Red

so in cell A10 I tried setting the Conditional Formatting formula as:

=LEFT(A10,20)="Returned to sender o"

that didn't seem to work so I tried

=LEFT(20)="Returned to sender o"

That didn't work. Is there a formula I can use in Conditional Formatting?

I have code that I can use but I would like to just set this up in Conditional Formatting if possible.

THANKS,
Mark

 

[VoG]

Hi. Working here with a different count

Excel Workbook
	A	B
10	Return to sender otherwise	26
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A10	1. / Formula is =LEFT(A10,18)="Return to sender o"	Abc

 

[Mister H]

Hi Peter:

I am not sure why that was not workinng for me (prior to posting) but it seems to work now

THANKS for your help AGAIN

Bye 4 Now,
Mark

 

[MrBill11]

Mister H
in Excel 2007 go to Conditional Formatting on the ribbon, Highlight Cells Rules, More Rules, Format Only Cells That Contain, Cell Value = Specific Text, Containing " Return To Sender, Format, Font, select color