View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
dido22 dido22 is offline
external usenet poster
 
Posts: 14
Default make a cell invisible

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