make a cell invisible

[dido22]

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

 

[James Ravenswood]

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.

 

[dido22]

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

K