I see a colon or semicolon when I "hide" cell contents

%3CLINGO-SUB%20id%3D%22lingo-sub-1717788%22%20slang%3D%22en-US%22%3EI%20see%20a%20colon%20or%20semicolon%20when%20I%20%22hide%22%20cell%20contents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1717788%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20building%20a%20calendar%20template.%20In%20a%20few%20cases%2C%20I%20have%20a%20logic%20function%20in%20a%20cell%20to%20indicate%20what%20background%20color%20to%20use%20in%20conditional%20formatting.%20The%20function%20returns%20a%201%2C2%2C3%2C%20or%204%20depending%20on%20the%20time%2C%20and%20I%20don't%20want%20these%20cell%20contents%20to%20be%20printed.%20I%20don't%20mind%20if%20I%20see%20a%20contents%20indicator%20when%20viewing%20the%20sheet%3B%20but%20when%20I%20print%2C%20I%20only%20want%20to%20see%20the%20background%20color.%3C%2FP%3E%3CP%3EI%20read%20in%20the%20Help%20menu%3B%20to%20%22achieve%22%20hidden%20cell%20contents%2C%20I%20add%20three%20semicolons%20(%3B%3B%3B)%20to%20the%20%22Custom%22%20Category%20%22Type%22%20field%2C%20in%20the%20%22Format%20Cells%22%20dialog%20box.%20I%20did%20this%20for%20these%20'indicator'%20cells%2C%20but%2C%26nbsp%3BI%20see%20a%20colon%20or%20semicolon%20when%20I%20print%20the%20sheet.%3C%2FP%3E%3CP%3EI'm%20just%20returning%20to%20Excel%20after%20years%20of%20absence%20since%20Office%20'98.%26nbsp%3B%20I%20vaguely%20remember%20a%20%22hide%20cell%20contents%22%20something%20or%20other%3B%20that%2C%20only%20reveals%20a%20%22cell%20note%22%20looking%20dog%20ear%20to%20indicate%20cell%20contents%2C%20and%20it%20did%20not%20show%20when%20printed.%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20read%2C%20and%20suggestions-%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20-%26nbsp%3B%20Jesse%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1717788%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1717884%22%20slang%3D%22de-DE%22%3ESubject%3A%20I%20see%20a%20colon%20or%20semicolon%20when%20I%20%22hide%22%20cell%20contents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1717884%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F810885%22%20target%3D%22_blank%22%3E%40Jucysterfry%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EIf%20I%20can%20recommend%20you%2C%20it%20is%20always%20better%20if%20you%20include%20a%20file%20(without%20sensitive%20data)%2C%20have%20done%20some%20preliminary%20work%20there%20and%20explain%20your%20plan%20on%20the%20basis%20of%20this%20file.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThis%20way%20you%20could%20come%20up%20with%20a%20proposed%20solution%20much%20faster.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EPlease%20consider%20that%20we%20help%20here%20voluntarily%20and%20are%20not%20paid%20to%20do%20the%20job.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EHelp%20to%20be%20helped.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3E%3CSPAN%20class%3D%22%22%3EThank%20you%20in%20advance%20for%20your%20patience%20and%20understanding%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I'm building a calendar template. In a few cases, I have a logic function in a cell to indicate what background color to use in conditional formatting. The function returns a 1,2,3, or 4 depending on the time, and I don't want these cell contents to be printed. I don't mind if I see a contents indicator when viewing the sheet; but when I print, I only want to see the background color.

I read in the Help menu; to "achieve" hidden cell contents, I add three semicolons (;;;) to the "Custom" Category "Type" field, in the "Format Cells" dialog box. I did this for these 'indicator' cells, but, I see a colon or semicolon when I print the sheet.

I'm just returning to Excel after years of absence since Office '98.  I vaguely remember a "hide cell contents" something or other; that, only reveals a "cell note" looking dog ear to indicate cell contents, and it did not show when printed. 

Thank you for your read, and suggestions- 

 

  -  Jesse

 

4 Replies
Highlighted

@Jucysterfry 

 

If I can recommend you, it is always better if you include a file (without sensitive data), have done some preliminary work there and explain your plan on the basis of this file.
This way you could come up with a proposed solution much faster.
Please consider that we help here voluntarily and are not paid to do the job.
Help to be helped.
 
Thank you in advance for your patience and understanding
 

Nikolino

I know I don't know anything (Socrates)

 
Highlighted

@Jucysterfry 

Is that like this what you do?

image.png

And do you see semicolons only when print or on screen as well?

Highlighted

I just checked, and discovered, I had used three colons ":::" instead of three semicolons ";;;" in the  "Custom" Category "Type" field, in the "Format Cells" dialog box.  I can see the difference now.

Thank you-

 

@Sergei Baklan 

Highlighted

@Jucysterfry 

Thanks for the update, glad to know you sorted this out