LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
mmb
 
Posts: n/a
Default Hide text in shaded cell

I am a frequent user of this board, but haven't needed to post before.. but
I'm really stumped.

I've got a spreadsheet, formatted to look like a 30 day calendar. I've
written multiple functions and used conditional formatting to shade certain
days that events are to occur.

This is where I have a problem.

On the unshaded days, the text is white. So, the calendar will print with
the formula results in white text, and viola -- hidden data.

However, the days I need shaded now show the text. I've tried changing my
conditional formatting to have the text and the shading to be the same
color.. great on screen.. invisible text. But the moment I try to print..
tiny numbers everywhere. (I've reduced the font to 8 to try to minimize the
damage.)

Normally, I'd just put in unbordered text boxes ... but multiple users with
multiple Excel versions means that would cause me more headaches than it's
worth.

Any ideas? Anyone know of any text/pattern combo that will minimize the
visibility of these formula results? Any suggestions would be MOST
appreciated.

Thanks!
 
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
for the experts Herman Excel Discussion (Misc queries) 2 October 28th 05 11:59 PM
How do I set text to top of cell next to wrap text in Excel? Carpenter Gary New Users to Excel 1 October 25th 05 06:26 PM
text to appear at top of cell jenniss New Users to Excel 4 August 30th 05 02:08 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Cell set to wrap text and blank line -- fix? Fred Holmes Excel Discussion (Misc queries) 0 January 25th 05 07:10 PM


All times are GMT +1. The time now is 08:31 PM.

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

About Us

"It's about Microsoft Excel"