Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
for the experts | Excel Discussion (Misc queries) | |||
How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
text to appear at top of cell | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) |