Conditional formatting

[alistair01]

I have 2 columns of data which are linked to other sheets. the first o
these can either contain Text or numbers. i would like to have exce
only display the values above 0

 

[Jason Morin]

Select column A, go to Format > Conditional Formatting,
Formula Is, and insert:

=OR(ISTEXT($A1),$A1<=0)

and format the font as white.

HTH
Jason
Atlanta, GA

 

[David McRitchie]

HI "alistair01 >" <<[email protected]> ,
You can do this with regular formatting
it will not change the value, just what is displayed.
General;;;
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[David McRitchie]

correction --- make that
General;;;@
to display numbers above zero
to not display negative numbers
to not display zero numbers
to display text values