View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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
.