Conditional Format

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

Excel 2000 ... I have cells containing formulas that may
or maynot produce various "Text" values ...

I wish to Conditional Format these cells regardless of
what "Text" value the formula returns. How do I write
this? ... Thanks ... Kha
 
You want the cell formatted if it contains text?

formula is: =ISTEXT(A1)

(with a1 the active cell in the selection)
 
Dave ...

I was using this formula ... However, I believe issue to
be "active cell". Your email tipped me off ... :)

My previous path:

Edit - Go To - Special - Conditional Format - Same ... I
was entering formula =istext(??) and bombing out. With
method I was using I could not seem to get 1st cell to
activate. That said ... I used your method & did 1 column
only ... Used Format Painter for remaining Cols ...

I am all set now ... Thanks ... Kha
 
Back
Top