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
-----Original Message-----
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
.
|