LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete rather than make Invisible Corey Excel Programming 6 May 11th 07 02:59 PM
make VbA invisible newbie in hell Excel Programming 3 April 10th 07 06:42 PM
Programmatically make cell pointer invisible XP Excel Programming 1 January 12th 06 04:39 PM
How Invisible Can You Make Your Code??? Chuckles123[_88_] Excel Programming 5 July 22nd 05 06:51 PM
Make one column Invisible. Neeraja Excel Programming 5 September 29th 03 02:58 AM


All times are GMT +1. The time now is 08:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"