make a cell invisible

  • Thread starter Thread starter dido22
  • Start date Start date
D

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
 
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.
 
Back
Top