Conditional formating Excel 2010

[jimshy]

Would like to format a given cell based on the "text" in another cell.
The "Use formula to determine which cells to format" does not seem to allow the use of "Text" in the "Edit the Rule Descripton"
A2=3 works
A2="EL" does not work
Is this a limitation of Excel 2010 - or is there a way to do this?

 

[Peter_SSs]

You need the formula
=A2="EL"

 

[VoG]

Works here

Excel Workbook
	A
1
2	EL
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =A2="EL"	Abc

 

[jimshy]

Thanks for the quick response - it works.....
Jim