Hello,

I have several long columns of numbers. I want to fade, or perhaps make
invisible, any number which is equal to the one above. Or, equivalently, to
highlight any number which is different to the one above.

I can do this with conditional formatting, though the rules get messy when
several columns are involved, or when the formats are copied from one row to
the next .

Are there any alternatives to conditional formatting ?

Thanks

K

There are several ways to make a cell invisible:

1. Put it in a hidden row or column
2. Make the cell font color the same as the cell background color
3. Set the cell format to ;;;
4. Use Protection

A macro can apply any of these rules to cells whose values equals the value of the cell above.

Thanks for the help, I knew some of the tricks, but the ;;; format was a new
idea.

K


"James Ravenswood" wrote in message
news:13394114.1392.1332017002650.JavaMail.geo-discussion-forums@vblb5...
There are several ways to make a cell invisible:

1. Put it in a hidden row or column
2. Make the cell font color the same as the cell background color
3. Set the cell format to ;;;
4. Use Protection

A macro can apply any of these rules to cells whose values equals the
value of the cell above.