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! |
Hide text in shaded cell
format the cell(s) as ;;;
"mmb" wrote in message ... 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! |
Hide text in shaded cell
I have a problem of this kind too. I have a grey box with a formula (if this cell = 0, 0, if not, this cell plus 45). When it shws 0, i don<t want the zero to be seen and when it is not 0, i want to see it. With an older version of office, i used contitionnal formatting and put the font of the text the same color of the box when i didn't want 0 to be seen but now, with that so helpful new version of office, when i print, i can see that 0. I's kind of ugly cause now my document is full of 0 while before we couldn't see it. Since i show the document to my customers, i need a cleaner document. The ;;; won't help me in my case because i would have to change my whole document just because i changed one thing in my sheet. I want conditionnal formatting to come back like the other Excel version. |
Hide text in shaded cell
If this cell=0, "",if not, this cell plus 45
"Elaine" wrote in message ... I have a problem of this kind too. I have a grey box with a formula (if this cell = 0, 0, if not, this cell plus 45). When it shws 0, i don<t want the zero to be seen and when it is not 0, i want to see it. With an older version of office, i used contitionnal formatting and put the font of the text the same color of the box when i didn't want 0 to be seen but now, with that so helpful new version of office, when i print, i can see that 0. I's kind of ugly cause now my document is full of 0 while before we couldn't see it. Since i show the document to my customers, i need a cleaner document. The ;;; won't help me in my case because i would have to change my whole document just because i changed one thing in my sheet. I want conditionnal formatting to come back like the other Excel version. |
All times are GMT +1. The time now is 07:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com