Conditional Formatting

[Michael]

I would like to use conditional formatting in a number of
cells. The condition I would like to highlight would be
if the cell contained text. ie. 1Y

Can anyone help me with this as I am fairly new...

Thanks!!
Mike

 

[Jason Morin]

1. Select your range.
2. Go to Format > Conditional Formatting.
3. Select "Formula Is" and insert the following:
=COUNTIF(INDIRECT("rc",0),"*1Y*")
4. Press the Format radio button and format as desired.

HTH
Jason
Atlanta, GA