Forum Discussion
Jucysterfry
Sep 27, 2020Copper Contributor
I see a colon or semicolon when I "hide" cell contents
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...
SergeiBaklan
Sep 28, 2020Diamond Contributor
Is that like this what you do?
And do you see semicolons only when print or on screen as well?
Jucysterfry
Sep 29, 2020Copper Contributor
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-
- SergeiBaklanSep 29, 2020Diamond Contributor
Thanks for the update, glad to know you sorted this out